856680 - Convert webdev cluster in scl3 to use all innodb, except where appropriate

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

convert dbs to all use innodb, except where appropriate, such as where there are fulltext searches.

Comment 1

[Sheeri Cabral [:sheeri]]

MariaDB [(none)]> select table_schema,count(*) from information_schema.tables where engine='myisam' and table_schema not in ('mysql','performance_schema','information_schema') group by table_schema with rollup;
+--------------------+----------+
| table_schema       | count(*) |
+--------------------+----------+
| arecibo            |       23 |
| bugzilla_mediawiki |        1 |
| builder_amo        |       24 |
| b_personas         |        8 |
| cb_personas        |        8 |
| c_apps             |       16 |
| c_flightdeck       |        6 |
| c_junk             |        7 |
| c_personas         |        7 |
| c_remora           |        1 |
| dll_directory      |        4 |
| f_bedrock          |        4 |
| f_bouncer_fromprod |       13 |
| f_bouncer_new      |       27 |
| f_pto              |        1 |
| graphite           |       15 |
| j_zamboni          |        1 |
| k_sheriff          |        4 |
| m_extendfirefox    |        1 |
| m_interns          |       17 |
| m_wordpress        |       11 |
| papal              |        1 |
| personas           |        8 |
| personas_junk      |        7 |
| remora             |        2 |
| remora-test        |        4 |
| summitr            |        4 |
| test_c_flightdeck  |       37 |
| z_flightdeck       |        1 |
| NULL               |      263 |
+--------------------+----------+
30 rows in set (0.11 sec)

Comment 2

[Sheeri Cabral [:sheeri]]

Done!

mysql> select table_schema,count(*) from information_schema.tables where engine='myisam' and table_schema not in ('mysql','performance_schema','information_schema') group by table_schema with rollup;
Empty set (0.03 sec)