Last modified: 2012-05-17 22:19:07 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T37872, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 35872 - centralauth db has myisam tables in production
centralauth db has myisam tables in production
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
unspecified
All All
: High normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2012-04-11 01:05 UTC by Asher Feldman
Modified: 2012-05-17 22:19 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Asher Feldman 2012-04-11 01:05:17 UTC 
The centralauth tables global_group_restrictions, globalblocks, spoofuser, and wikiset are using the MyISAM storage engine.

In addition to the site concurrency issues, MyISAM isn't crash safe, and this was noticed when replication broke to an s7 slave after a crash due to key corruption. 

Migrate soon.
Comment 1 Mark A. Hershberger 2012-04-11 20:45:37 UTC 
RT #2811
Comment 2 Rob Lanphier 2012-04-12 18:29:14 UTC 
Asher, my understanding is that you should be able to put this on your backlog.  I briefly discussed this with Tim, and we don't see any reason why this can't just be done at the db level without a lot of application support.
Comment 3 Chad H. 2012-04-12 18:31:09 UTC 
Only think to make sure of with CentralAuth itself is to make sure it's schema file(s) specify $wgDBTableOptions so no one else gets bit by this again. But yeah, Rob's right, this is an ops issue.
Comment 4 Asher Feldman 2012-05-17 22:19:07 UTC 
These have all been migrated, spoofuser (13.5mil rows) via osc, the others as straight alters on the master.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links