Buy Percona ServicesBuy Now!

This Week in Data with Colin Charles 39: a valuable time spent at rootconf.in

 | May 11, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Events and Announcements, MyRocks, MySQL, MySQL 8.0, Percona Live

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. rootconf.in 2018 just ended, and it was very enjoyable to be in Bangalore for the conference. The audience was large, the conversations were great, and overall I think this is a rather important conference if you’re […]

Read More

How Binary Logs (and Filesystems) Affect MySQL Performance

 | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a […]

Read More

Percona Live 2018 Community Report

 | May 4, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, open source databases, Percona Live, PostgreSQL

So, after a whirlwind few days, Percona Live 2018 has been and gone. There was a great energy about the conference, and it was fantastic to meet so many open source database enthusiasts and supporters. A few things that I experienced: Your great willingness to share knowledge. It was a fantastic place to learn for […]

Read More

Q&A: “Percona XtraDB Cluster 5.7 and ProxySQL for Your High Availability Needs” Webinar

and  | May 3, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Technical Webinars

High Availability

On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar experience. We tried answering some of your high […]

Read More

Causes and Workarounds for Slave Performance Too Slow with Row-Based Events

 | May 3, 2018 |  Posted In: High-availability, Insight for DBAs, MySQL, Replication

Slave Performance Too Slow

Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary log. For example:

The processlist state for the SQL thread can be one of the following: Reading […]

Read More