MySQL Performance Blog

I’m happy to announce availability of MySQL Performance Forums on MySQL …forum is created as free alternative to MySQL Consulting Services which we provide. If …LAMP Forum for Web Application scaling and performance topics, whatever database you’re using …

… had a chance to check out MySQL Performance on “Memory Appliance” by Violin … I got even a bit better performance. Interesting enough utilization in iostat never … cycles handling them without taking large performance hit. I really hope this would …

…. What are we expecting from MySQL Performance Engineer ? Such person should have … what happens on all layers (MySQL, Operation System, Hardware) when for example… friend. One should have good MySQL knowledge including main storage engines, …

As I already announced last week I started MySQL Performance Forums project focusing on MySQL Performance … is the list for last week: Ways to perform full text search on Chinese texts with MySQL Replication of Summary tables only Overhead of …

…(often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while there well…just grab one having allocation very quick. Also MySQL should get smarter in terms of which …

Percona, the company maintaining MySQL Performance Blog has a good presence on…list of sessions we have: Sphinx: High Performance Full Text Search for MySQL (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb …

… are some tools we commonly use doing performance review and optimization and we often ask …So now you can find our favorite MySQL Performance Review Tools on the site. … tools which are helpful for “in time” performance audit - for example you see no …

… search if I wanted to find something on MySQL Performance Blog. Today we have published new search functionality for our site which is …and for SEO. Hope this addition will make MySQL Performance Blog more useful for you.

…the first rules you would learn about MySQL Performance Optimization is to avoid using …column value needs to do the filesort: mysql> explain select * from tst where i=5… cases when this would be possible: mysql> explain select * from tst where i=5…

… how we can use them for MySQL Performance tuning ? Not surpising associative array … - closest competitor. In real life performance difference can be evel larger as …data on network with memcached. Memcache performs worse than file cache (even though…