856673 - Convert builder-addons dbs to all use 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]]

6 tables are MyISAM, none are fulltext:


mysql>  select distinct table_schema,table_name from information_schema.statistics where index_type='fulltext'; Empty set (0.02 sec)
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;
+----------------------------+----------+
| table_schema               | count(*) |
+----------------------------+----------+
| builder_addons_mozilla_org |        6 |
| NULL                       |        6 |
+----------------------------+----------+
2 rows in set (0.00 sec)

Comment 2

[Sheeri Cabral [:sheeri]]

mysql> select table_name from information_schema.tables where table_schema='builder_addons_mozilla_org' and engine='myisam';
+--------------------+
| table_name         |
+--------------------+
| schema_version     |
| waffle_flag        |
| waffle_flag_groups |
| waffle_flag_users  |
| waffle_sample      |
| waffle_switch      |
+--------------------+
6 rows in set (0.00 sec)

These might be django tables.....

Comment 3

[Sheeri Cabral [:sheeri]]

This db has since been decommissioned.