slider

Tag: dictionary corruption

Temporary Table Naming Scheme In 5.6 And Before

Benchmarking is a popular topic. People love drawing graphs as much as watching how X is 10% faster than Y; there must be something special about measurements. For a DBA, however, more tangible improvements come from a less popular area of database maintenance. While MariaDB spreads FUD around InnoDB (which still uses it), I have […]

Read More

Resolving ERROR 1050 42S01 At Line 1 Table Already Exists

When ALTER TABLE crashes the MySQL server, it leaves orphaned records in the InnoDB dictionary. It is annoying because next time you run the same ALTER TABLE query, it will fail with error: ERROR 1050 (42S01) at line 1: Table ‘sakila/#sql-ib712’ already exists This post explains why it happens and how to fix it. When […]

Read More