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
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 if its files got corrupted and even innodb_force_recovery=6 doesn’t help. The corruption of InnoDB tablespace may be caused by many reasons. A dying hard drive can write garbage, thus, page […]
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.