Page MenuHomePhabricator

toolsdb: reduce number of myisam tables
Open, Needs TriagePublic

Description

ToolsDB has some MyISAM tables:

MariaDB [information_schema]> select ENGINE, count(*) from tables where ENGINE in ('InnoDB', 'MyISAM') group by ENGINE;
+--------+----------+
| ENGINE | count(*) |
+--------+----------+
| InnoDB |     8778 |
| MyISAM |      482 |
+--------+----------+
2 rows in set (0.74 sec)

Since AIUI InnoDB deals better with replication than MyISAM does, this task is to check if some/most of those tables can be converted to InnoDB.

Event Timeline

Since AIUI MyISAM deals better with replication

Just double-checking, you're saying that myisam is easier to replicate, but we still want to move these tables to innodb for consistency?

Since AIUI MyISAM deals better with replication

Just double-checking, you're saying that myisam is easier to replicate, but we still want to move these tables to innodb for consistency?

No, sorry, I'm getting things mixed up here somehow. InnoDB is the one that I've been told that it has a better replication mechanism.

Talking with @fnegri this could also help avoiding corruption in case of disk failure/power outage/etc., as InnoDB seems to be more resilient to that kind of issues.