EmergencyEMERGENCY? Get 24/7 Help Now!

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

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

 | March 14, 2013 |  Posted In: Events and Announcements, Insight for Developers, MySQL

While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10. This turned into a really nice exercise for checking the performance and inner workings of one […]

Read More