Author Archives: aadant

Performance_schema success stories : replication SQL thread tuning

Posted on March 27, 2014 by aadant

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

Posted on March 19, 2014 by aadant

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

Posted on March 7, 2014 by aadant

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 ?

Posted on February 4, 2014 by aadant

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

Posted on December 20, 2013 by aadant

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

Posted on September 30, 2013 by aadant

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

Posted on September 25, 2013 by aadant

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

Posted on September 9, 2013 by aadant

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