856677 - Convert getpersonas cluster in scl3 to all use innodb, except where appropriate

Status: RESOLVED WONTFIX

(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]]

7 tables, none have fulltext indexes:

mysql>  select distinct table_schema,table_name from information_schema.statistics where index_type='fulltext'; 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.02 sec)

+--------------+----------+
| table_schema | count(*) |
+--------------+----------+
| personas     |        7 |
| NULL         |        7 |
+--------------+----------+
2 rows in set (0.00 sec)

mysql> select table_schema,table_name from information_schema.tables where engine='myisam' and table_schema not in ('mysql','performance_schema','information_schema') ;
+--------------+--------------+
| table_schema | table_name   |
+--------------+--------------+
| personas     | categories   |
| personas     | edits        |
| personas     | favorites    |
| personas     | log          |
| personas     | meta         |
| personas     | ssc_personas |
| personas     | users        |
+--------------+--------------+
7 rows in set (0.00 sec)

Comment 2

[Sheeri Cabral [:sheeri]]

personas is now in addons.