Author - Peter Zaitsev

RED Method for MySQL Performance Analyses

RED MySQL Performance

The RED Method (Rate, Errors, Duration) is one of the more popular performance monitoring approaches.  It is often applied to Monitoring Microservices though there is nothing that prevents it from being applied to databases like MySQL.
In Percona Monitoring and Management (PMM) v2 we have all the required information stored in the ClickHouse database, and […]

Read more

MySQL Bug Reporter Hall of Fame

MySQL Bug Reporter Hall of Fame

Recently, I got access to the list of MySQL bug reports from bugs.mysql.com which someone crawled and stored in a MySQL database. I thought it would be interesting to see who the heroes are of MySQL bug reporting!
Top MySQL Bug Reporters Ever

Shell

select rank() over(order by count(*) desc) my_rank, count(*) cnt, reporter from bugs where […]

Read more

Benchmarking: More Stable Results with CPU Affinity Setting

benchmarking cpu affinity setting

When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good choice to run a benchmark program, as well as the database, on the same server. This is in order to eliminate network impact and to look at single-thread performance, to eliminate contention.
Usually, this approach […]

Read more

Need to Connect to a Local MySQL Server? Use Unix Domain Socket!

Unix Socket Domain

When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address –  “localhost” or 127.0.0.1  – or use Unix Domain Socket.
If you have a choice (if your application supports both methods), use Unix Domain Socket as this is both more secure and more efficient.
How […]

Read more