Author Archives: aadant

Performance_schema success stories : replication SQL thread tuning

A lot of customers have lagging slaves. It could be one of the top issues at support, due to the infamous row based replication without primary key issue : Bug #53375 RBR + no PK => High load on slave (table … Continue reading

Posted in Uncategorized | Leave a comment

Performance_schema success stories : host summary tables

This question was asked at support by a customer to solve a difficult issue. How to identify a sporadic burst of queries coming from one of the hosts accessing the database ? If there are hundreds of hosts, it can … Continue reading

Posted in performance_schema, success stories, tip, Uncategorized | Leave a comment

50 tips to boost MySQL Performance Webinar follow up

Thank you for attending the webinar !  Here are the ppt slides. If you missed it, you can still join the archived event by clicking the URL below. http://w.on24.com/r.htm?e=748845&s=1&k=171F8C0CECD105B0F4ED721CA6F2C704 There were a lot of attendees and a lot of questions. … Continue reading

Posted in conference, tip, Uncategorized | 2 Comments

How to calculate a specific InnoDB index size ?

MySQL provides commands to see the overall index size versus the data size. One of them is “show table status” :

So here, we have these “estimations”, run ANALYZE TABLE before to get more accurate estimates : Data_length: 143310848, … Continue reading

Posted in tip | Leave a comment

A small optimizer change worth noticing

MySQL uses internal temporary tables to execute some queries. Usually the tables are stored in memory and on disk if some conditions are met : Some conditions prevent the use of an in-memory temporary table, in which case the server … Continue reading

Posted in tip | Leave a comment

Poor man’s Online Optimize in 5.6

Table space fragmentation has generally 2 origins : File System fragmentation : the data file is spread physically on many non contiguous locations on the disk. Internal Fragmentation : the data and index pages have “holes” : this happens when  … Continue reading

Posted in online DDL, tip | 2 Comments

MySQL Connect slides

Thank you for attending MySQL Connect 2013. The Saturday session 50 Tips for Boosting MySQL Performance [CON2655] was sold out. It shows the interest in practical recipes to solve performance problems. Maybe the topic of a book as suggested by … Continue reading

Posted in conference | Leave a comment

I am speaking at MySQL Connect 2013

I open this blog to announce that I will be speaking at MySQL Connect in 2 weeks.  I will present a conference session : 50 Tips for Boosting MySQL Performance [CON2655], Saturday 21 Sept, 1PM and a tutorial session : … Continue reading

Posted in conference | Leave a comment