EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs

 | June 3, 2016 |  Posted In: MySQL, MySQL 5.7

binary logs make MySQL 5.7 slower

Researching a performance issue, we came to a startling discovery: MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings. Test server MySQL versions used: i7, 8 threads, SSD, Centos 7.2.1511 mysql-5.6.30-linux-glibc2.5-x86_64 mysql-5.7.12-linux-glibc2.5-x86_64 mysqld –options: --no-defaults --log-bin=mysql-bin --server-id=2 Run details: Sysbench version 0.5, 4 threads, socket file connection […]

Read More

Webinar Q & A for Introduction to Troubleshooting Performance: What Affects Query Execution?

 | April 16, 2016 |  Posted In: MySQL

Query Execution

In this blog, I will provide answers to the Webinar Q & A for Introduction to Troubleshooting Performance: What Affects Query Execution? First, I want to thank you for attending the April, 7 webinar. This webinar is the third in the “MySQL Troubleshooting” webinar series and last introductory webinar in the series. The recording and […]

Read More

Increasing Cloud Database Efficiency – Like Crows in a Closet

 | February 25, 2015 |  Posted In: Tokutek, TokuView

In Mo’ Data, Mo’ Problems, we explored the paradox that “Big Data” projects pose to organizations and how Tokutek is taking an innovative approach to solving those problems. In this post, we’re going to talk about another hot topic in IT, “The Cloud,” and how enterprises undertaking Cloud efforts often struggle with idea of “problem […]

Read More

Mo’ Data, Mo’ Problems

 | January 22, 2015 |  Posted In: Tokutek, TokuView

Welcome to blog #2 in a series about the benefits of the Fractal Tree. In this post, I’ll be explaining Big Data, why it poses such a problem and how Tokutek can help. Given the fact that I am a lifelong fan of both Hip-hop and Big Data, the title was a no-brainer and, given […]

Read More

MySQL’s INNODB_METRICS table: How much is the overhead?

 | November 18, 2014 |  Posted In: Benchmarks, InnoDB, MySQL

Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA. Too bad INNODB_METRICS was designed during the Oracle-Sun split under MySQL leadership and so it covers only InnoDB counters. I think this […]

Read More

“How to monitor MySQL performance” with Percona Cloud Tools: June 25 webinar

 | June 18, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars, Percona Cloud Tools

We recently released a new version of Percona Cloud Tools with MySQL monitoring capabilities. Join me June 25 and learn the details about all of the great new features inside Percona Cloud Tools – which is now free in beta. The webinar is titled “Monitoring All (Yes, All!) MySQL Metrics with Percona Cloud Tools” and begins at […]

Read More

Optimizing MySQL Performance: Choosing the Right Tool for the Job

 | April 7, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars

Next Wednesday, I will present a webinar about MySQL performance profiling tools that every MySQL DBA should know. Application performance is a key aspect of ensuring a good experience for your end users. But finding and fixing performance bottlenecks is difficult in the complex systems that define today’s web applications. Having a method and knowing how […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.