+1 (844) 533-0409

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 in measurements. For a DBA, however, more tangible improvements come from less popular area of database maintenance. While MariaDB spreads FUD around InnoDB (nonetheless still uses it) I have to […]

Continue Reading »

Resolving page corruption in compressed InnoDB tables

Screenshot 2014-10-27 15.19.34

Sometimes corruption is not the true corruption. Corruption in compressed InnoDB tables may be a false positive. Compressed InnoDB table may hit false checksum verification failure. The bug (http://bugs.mysql.com/bug.php?id=73689) reveals itself in the error log as follows:

InnoDB complains that a stored checksum is zero. If you look closely it’s suspicious that calculated checksum […]

Continue Reading »

Resolving ERROR 1050 42S01 at line 1 Table already exists

When ALTER TABLE crashes MySQL server it leaves orphaned records in InnoDB dictionary. It is annoying because next time you run the same ALTER TABLE query it will fail with error:

The post explains why it happens and how to fix it. When you run ALTER table InnoDB follows the plan: Block the original […]

Continue Reading »
Loading...