Efficient Use Of Indexes In MySQL
These are the slides of the “Efficient Use Of Indexes In MySQL” talk we delivered on the SFMySQL Meetup. This is an introductory talk for developers on MySQL indexes. In my opinion, it’s quite important to understand how InnoDB organizes data. If you know how MySQL accesses data, it’s easier to write optimal queries. When working […]
Taking An Image From Corrupted Hard Drive
There are at least two cases when it makes sense to take an image from a corrupted hard drive as soon as possible: disk hardware errors and a corrupted filesystem. Faulty hard drives can give just one chance to read a block, so there is no time for experiments. It’s pretty much the same with corrupted […]
Recovering A Corrupt MySQL Database
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. The unDROP for InnoDB tool can be used to recover corrupt MySQL databases. In this post, we will show how to repair a MySQL database […]
Ibdconnect And Secondary Keys
Ibdconnect is a tool to connect an ibd file to a foreign ibdata file. It’s important to understand how it works as secondary keys may cause peculiar behavior.