EmergencyEMERGENCY? Get 24/7 Help Now!

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

Tuning InnoDB Concurrency Tickets

 | May 24, 2010 |  Posted In: Benchmarks, Insight for DBAs, MySQL

InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if the number of threads has already reached the concurrency limit. When a thread […]

Read More

Effect of adaptive_flushing

 | December 4, 2009 |  Posted In: Benchmarks, MySQL

I recently had the chance to witness the effects of innodb_adaptive_flushing on the performance of InnoDB Plugin 1.0.5 in the wild, which Yasufumi wrote about previously here and here. The server in question was Solaris 10 with 8 disk RAID10 and 2 32GB SSDs used for ZIL and L2ARC, 72G RAM and 40G buffer pool. […]

Read More

Tuning for heavy writing workloads

 | October 14, 2009 |  Posted In: Benchmarks, Insight for DBAs, MySQL

For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, <tuning peak performance>. The next, <tuning purge operation> to stabilize […]

Read More

Which adaptive should we use?

 | September 15, 2009 |  Posted In: Benchmarks, Percona Software

As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from physical size of the buffer pool. And the another one is oldness of the block which is from the capacity of transaction log files. In the case of heavy updating workload, the modified ages of […]

Read More

Scaling IO Bound Workloads Webinar

 | June 19, 2009 |  Posted In: Events and Announcements

I will co-present in webinar on Performance Challenges and Solutions for IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is such an important event, how to prepare to it as well as how to keep your application performance good as […]

Read More