If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

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

RESOLVED WONTFIX

Status

Data & BI Services Team
DB: MySQL
RESOLVED WONTFIX
5 years ago
3 years ago

People

(Reporter: sheeri, Unassigned)

Tracking

Details

(Reporter)

Description

5 years ago
convert dbs to all use innodb, except where appropriate, such as where there are fulltext searches.
(Reporter)

Comment 1

5 years ago
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)
(Reporter)

Comment 2

5 years ago
personas is now in addons.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → WONTFIX
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.