MySQL Performance Blog

The biggest site which uses nginx (nginx/0.5.30) is youporn.com, #40 at Alexa (see http://static.youporn.com/css/) Hulu is way below.

Looking at post by Konstantin Osipov we should finally get Query Cache working with prepared statements in MySQL 5.1 The interesting thing Konstantin notes it just took few days to fix it – I believe MySQL Support Team alone spent much more times …

…but what is interesting is the server line which shows nginx 0.5.32 I have checked and indeed images served from assets.hulu.com have nginx server in response header. This would be the first site of this (planned) scale to run Nginx. So far even…

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 …

Peter Zaitsev: Now I work as Independent MySQL Consultant specializing in MySQL Performance Previously I was employed as Manager of High Performace Group at MySQL Inc, I specialise MySQL Server performance as well as in performance of …

UPDATE: This page is no more updated. For new Presentations which we gave please check Presentations area on Percona company site. This page lists MySQL related Talks MySQL Performance Blog team members gave during the last years. Hope you find them…

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 …

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 …

… feature Also if you’re looking to do full text search with Innodb you may give a try to http://www.sphinxsearch.com/ It works with any table types and is normally much faster than build in FullText search. The integration is not as seemless as …

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 – …