828450 - [meta] Audit MyISAM usage and get rid of MyISAM tables that exist

Status: RESOLVED WONTFIX

(Data & BI Services Team :: DB: MySQL, task)

Description

[Sheeri Cabral [:sheeri]]

Let's audit the use of the MyISAM tables that exist, and work on converting the inappropriate databases.

Rob made a facter script to easily find the MyISAM tables:

https://bugzilla.mozilla.org/show_bug.cgi?id=784031

Comment 1

[Sheeri Cabral [:sheeri]]

In scl3:

bugzilla1 => 1
bugzilla1 => 3
bugzilla2 => 1
bugzilla2 => 3
bugzilla3 => 1
bugzilla4 => 1
buildbot1 => 33
buildbot2 => 33
builder-addons1 => 6
builder-addons2 => 6
db1 => 23
db2 => 1
dev1 => 1
dev2 => 1
developer1 => 189
developer2 => 189
devtools1 => 221
devtools2 => 221
generic1 => 52
generic2 => 52
getpersonas1 => 7
getpersonas2 => 7
intranet1 => 6
intranet2 => 6
mysql1 => 633
stage1 => 2125
stage2 => 2125
sumotools1 => 872
webdev1 => 256
webdev2 => 256

in phx1:
support1 => 74
dev1 => 4796
dev2 => 4796
addons1 => 1
addons1 => 17
addons2 => 1
addons2 => 17
addons3 => 1
addons3 => 17
addons4 => 1
addons4 => 17
addons5 => 1
addons5 => 17
addons6 => 1
addons7 => 1
bugzilla1 => 1
generic1 => 393
generic2 => 393
intranet1 => 225
intranet2 => 225
jenkins1 => 34
sumotools1 => 86
support1 => 74
support2 => 74
support3 => 74
support4 => 74
tp-a01-master01 => 29
tp-a01-slave01 => 29
tp-a01-slave02 => 29
tp-b02-master01 => 121
tp-b02-slave01 => 121
tp-bouncer01-master01 => 27
tp-bouncer01-slave01 => 27
tp-bouncer01-slave02 => 27
tp-bouncer01-slave03 => 27
tp-bugs01-master01 => 1
tp-bugs01-slave01 => 1
tp-bugs01-slave02 => 1
tp-bugs01-slave03 => 1

Comment 2

[Sheeri Cabral [:sheeri]]

I've created https://etherpad.mozilla.org/MyISAMtables2013 to track these.

Comment 3

[Sheeri Cabral [:sheeri]]

buildbot needs to work with MyISAM, so they're OK.

Comment 4

[Sheeri Cabral [:sheeri]]

Not worth the time investment.