Buy Percona ServicesBuy Now!

Friday challenge: ibd recovery

 | May 15, 2009 |  Posted In: Insight for DBAs

I want to make this Friday a bit more interesting – how do you feel to train a bit in InnoDB data recovery techniques. I have .ibd datafile which was created by query CREATE TABLE `tryme` ( `email` mediumblob, `content` mediumblob ) ENGINE=InnoDB … (SOME PARAMETERS SKIPPED) …; and I inserted one record into this […]

Read More

Covering Indexes: Orders-of-Magnitude Improvements

 | May 14, 2009 |  Posted In: Tokutek, TokuView

The talk I gave at the Percona Performance Conference at the MySQL Users Conference in April 2009 can be found here. This talk provides some examples where covering indexes help, and then describes a performance model that can be used to understand and predict query performance. It covers clustering indexes (which are a kind of […]

Read More

Global Transaction ID and other patches available!

 | May 13, 2009 |  Posted In: Percona Software

I do not know if you noticed it, but Google (Mark Callaghan, Justin Tolmer and their internal mysql-team) made a great contribution to MySQL. Patches global transaction IDs, binlog event checksums and crash-safe replication state are separated and published on Launchpad ( For me it was a big wall in using these patches that they […]

Read More

MySQL Meetups Sponsorship Available

 | May 13, 2009 |  Posted In: Events and Announcements

As you know Sun/MySQL and could not agree on terms of the sponsorship and so now all MySQL meetup organizers have to pay for their Meetups or move them to the different location. Facebook is suggested as one of alternatives. I’m not to take any sides in this story and judge who is wrong […]

Read More

read_ahead (disabled) as steroid

 | May 12, 2009 |  Posted In: Benchmarks, Insight for DBAs

Last week we were busy to align XtraDB performance with 5.4, now we have some results. Currently it is available as “hacks” to XtraDB (available on Lauchpad lp:~percona-dev/percona-xtradb/hacks-porting-tune if you are interested). Basically we took improvements from 5.4 and backported ones performance related to XtraDB. Here are results for tpcc-like workload, 100W (~10GB) ( raw […]

Read More

Friday challange: linking with GPL code

 | May 8, 2009 |  Posted In: Events and Announcements

This is rather a theoretical interest for me for now (what else to do Friday evening) , but I see how it can be used in current dual-licensed mixed open / closed source storage engines MySQL world. So problem is: Let’s keep MySQL aside for simplicity and imagine we have fully open-source GPLvX licensed “MoonOffice” […]

Read More

Btw xtrabackup is not only backup..

 | May 7, 2009 |  Posted In: Percona Software

It is obvious thing for me, but I just figured out it may be not common understanding. Xtrabackup is also can be used (not only can, but we actually use it this way) to clone one slave to another, or just setup new slave from the master. And it is done in almost non-blocking way […]

Read More