EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server: Thread Pool Improvements for Transactional Workloads

 | January 29, 2014 |  Posted In: Benchmarks, MySQL, Percona Server

In a previous thread pool post, I mentioned that in Percona Server we used an open source implementation of MariaDB’s thread pool, and enhanced/improved it further. Below I would like to describe some of these improvements for transactional workloads. When we were evaluating MariaDB’s thread pool implementation, we observed that it improves scalability for AUTOCOMMIT […]

Read More

Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2

 | April 15, 2013 |  Posted In: Benchmarks, MySQL, Percona Software

In addition to the problem with trx_list scan we discussed in Friday’s post, there is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this structure from heap. The problem is that the heap for that allocation is destroyed on […]

Read More