Efficient Use of Indexes in MySQL
The slides of “Efficient Use of Indexes in MySQL” talk we delivered on 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 with queries I […]
Take 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 corrupted filesystem. Faulty hard drives can give just one chance to read a block, so there is no time for experiments. The similar picture with corrupted filesystems. Obviously something […]
Recover 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 do not support its open source versions. The unDROP for InnoDB tool can be used to recover corrupt MySQL database. In this post we will show how to repair MySQL database if […]
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 interesting behavior.