EmergencyEMERGENCY? Get 24/7 Help Now!

Getting MySQL to use full key length

 | January 31, 2007 |  Posted In: Insight for DBAs

There is one bug, or “missing feature” in MySQL Optimizer which may give you hard time causing performance problems which may be hard to track down, it is using only part of the index when full index can be used or using shorter index while there is longer index available. The last item is yet […]

Read More

Linux IO Schedulers and MySQL

 | January 30, 2007 |  Posted In: Hardware and Storage

Found a great article about Linux IO Schedulers today which is quite interesting. It goes in details about schedulers and explains in which of workloads which of schedulers is best. The interesting thing this article points out is – there are multiple versions of each of the schedulers, while name remains the same. This means […]

Read More

Making MySQL Replication Parallel

 | January 30, 2007 |  Posted In: Insight for DBAs

Kevin Burton writes about making MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in reality it is only able to use only single CPU and single disk effectively which is getting worse and worse as computers are getting “wider” these days with multi-core CPUs. Kevin […]

Read More


 | January 19, 2007 |  Posted In: Insight for DBAs

We all know disk based temporary tables are bad and you should try to have implicit temporary tables created in memory where possible, do to it you should increase tmp_table_size to appropriate value and avoid using blob/text columns which force table creation on the disk because MEMORY storage engine does not support them Right ? […]

Read More

MySQL Binaries availability

 | January 19, 2007 |  Posted In: Events and Announcements

It looks like it looks like there are going a lot of discussions about future of MySQL Community Binaries, see for example this post and Kaj’s clarifications. Obviously now it grew to a lot of speculations and many comments are far from real story. It is also really interesting to watch MySQL try to balance […]

Read More

Performance impact of complex queries

 | January 17, 2007 |  Posted In: Insight for Developers

What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which were taking milliseconds to stall for few seconds, especially in certain OS configurations, and on low profile servers (ie having only one disk drive) […]

Read More

Speaking at MySQL Users Conference 2007

 | January 16, 2007 |  Posted In: Events and Announcements

Just got email from Jay today about two of my talks being accepted to MySQL Users Conference 2007 “MySQL Server Settings Tuning” and “MySQL Performance Cookbook”. This is great as MySQL Conferences are always fun and great way to get to know people and learn things about MySQL and connected areas. This will be my […]

Read More

Some of our articles are translated to Russian

 | January 16, 2007 |  Posted In: Events and Announcements

A friend pointed out to me number of our our articles were translated and included in PHPInside.RU – electronic magazine about PHP and surrounding technologies which of course include MySQL. You can download PDF for free right here. We love our articles being translated and or republished, as long as they are available for free […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.