Innodb Fuzzy checkpointing woes

As you might know Innodb storage engines uses Fuzzy Checkpointing technique as part of it recovery strategy.  It is very nice approach which means database never needs to “stall” to perform total modified pages flush but instead flushing of dirty pages happens gradually in small chunks so database load is very even.
This works great […]

Read more

Descending indexing and loose index scan

Comments to my previous posts, especially this one by Gokhan inspired me to write a bit about descending indexes and about loose index scan, or what Gokhan calls “better range” support. None of these are actially related to Innodb tables in general – these are features MySQL should get for all storage engines at […]

Read more

Site goes lives

Numerous talks at MySQL Users Conference and a lot of people asking me for my presentations motivated me to speed up launching of this site. I hope it will also motivate me to blog more frequently about performance as blog name implies.
If you’re looking for presentations they are here. All of mine presentations which […]

Read more