EmergencyEMERGENCY? Get 24/7 Help Now!

Impact of the number of idle connections in MySQL (version 2)

 | December 20, 2010 |  Posted In: Insight for DBAs, MySQL

Last Friday I published results of DBT2 performance while varying the number of idle connections here, but I had compiled MySQL with the debugging code enabled. That completely screw up my results, be aware… debug options have a huge performance impact. So, I recompiled Percona-Server 11.2 without the debug options and did another benchmark run. […]

Read More

Impact of the sort buffer size in MySQL

 | October 25, 2010 |  Posted In: Benchmarks, MySQL

The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is a per session buffer that is allocated every time it is needed. The problem with the sort buffer comes from the way Linux allocates memory. Monty Taylor (here) have described the underlying issue in detail, but basically above […]

Read More

High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script

 | October 22, 2010 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, MySQL

This post is the fifth of a series that started here. From the previous posts of this series, we now have an instance restart script that can restart the database node in case of failure and automatically reconfigure Pacemaker and the other servers that needs to access the MySQL server. What we will cover in […]

Read More