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
At Users Conference Heikki did good presentation about Innodb planned features. I did not see some of big and tiny wishes listed so I was making notes. Here is what I’d like to see
Packed indexes. In many cases then difference in Performace with MyISAM and Innodb is huge for read only workload it is […]Read more
During the recent months I’ve seen few cases of customers upgrading to MySQL 5.0 and having serious performance slow downs, up to 10 times in certain cases. What was the most surprising for them is the problem was hardware and even OS specific – it could show up with one OS version but not […]Read more
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 […]