slider

Author: Aleksandr Kuzminsky

Resolving Page Corruption In Compressed InnoDB Tables

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

InnoDB complains about a stored checksum being a zero. If you look closely, you’ll find it […]

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:

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

Read More

Recover Table Structure From InnoDB Dictionary

When a table gets dropped, MySQL removes the respective .frm file. This post explains how to recover the table structure if the table was dropped. You need the table structure to recover a dropped table from the InnoDB tablespace. The B+tree structure of the InnoDB index doesn’t contain any information about field types. MySQL needs […]

Read More

Repair Corrupted InnoDB Tables With Secondary Index Corruption

UPDATE: We announced online data recovery from corrupt databases. Check it out on https://recovery.twindb.com/ UPDATE (01/01/2017): We stopped further development of undrop-for-innodb and don’t support its open source versions anymore. InnoDB provides no means to repair corrupted table space. Once a table got corrupted, the only way to repair MySQL files is to start it […]

Read More

Setting Up Authentication En Masse

Managing many hosts is a quite challenging task. There are many tools to solve the problem. My favorite is pdsh. Running a command across a set of hosts is as simple as following:

Together with dshbak (which is a part of pdsh package) you can do even cooler things. Like, check which systems have […]

Read More

InnoDB Dictionary

Why Does InnoDB Need A Dictionary An InnoDB dictionary is a set of internal tables InnoDB uses to maintain various information about user tables. It serves as API between a human and the database. While the humans refer to tables by their names, InnoDB works with integer identifiers. The dictionary stores correspondence between table name […]

Read More