slider

Author: Aleksandr Kuzminsky

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

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

A Real Example Of Nagios Monitoring

It’s now time to setup proper monitoring to avoid unpleasant surprises in future. There are two major problems the monitoring solves: alerting and trending. Alerting is to notify the person in charge about a major event like service failing to work. Trending is to track the change of something over time – disk or memory […]

Read More