856675 - Convert devtools cluster 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]]

mysql> select table_name,table_schema from information_schema.tables where engine='myisam' and table_schema not in ('mysql','performance_schema','information_schema');
+------------+-------------------------+
| table_name | table_schema            |
+------------+-------------------------+
| log        | getpersonas_allizom_org |
+------------+-------------------------+
1 row in set (0.01 sec)

mysql>  select distinct table_schema,table_name from information_schema.statistics where index_type='fulltext'; 
Empty set (0.04 sec)

These are OK to keep MyISAM.