by Peter Zaitsev | Jun 25, 2014 | Insight for DBAs, MySQL
Earlier this month I wrote about vmstat iowait cpu numbers and some of the comments I got were advertising the use of util% as reported by the iostat tool instead. I find this number even more useless for MySQL performance tuning and capacity... by Vinicius Grippa | May 2, 2023 | Database Trends, Insight for DBAs, MySQL
Given the increasing popularity of ChatGPT in solving questions of humankind, I decided to take a better look at the current state of AI. At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. As the... by Fernando Laudares Camargos | Jun 4, 2021 | Insight for DBAs, MySQL
The combination of the information obtained from the “pt-summaries” discussed in the previous posts of this series (Part 1: The Percona Support Way, Part 2: Knowing the Server, Part 3: What MySQL?) helps us come up with the first impression of a MySQL... by Fernando Laudares Camargos | Jun 1, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
When I joined the Percona Support team in early 2013, MySQL 5.6 was being launched. I remember all the buzz and euphoria surrounding its release: it was a big step from the 5.5 series, carrying important changes in the MySQL architecture and internals that brought... by Michael Patrick | Apr 7, 2021 | MySQL, Open Source, Percona Services, Percona Software
So your MySQL server has crashed. What do you do now? When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected: Save diagnostic information for determining the root cause... by Juan Arruti | Apr 23, 2020 | Insight for DBAs, Monitoring, MySQL
One of our customers recently asked whether it is possible to identify, from the MySQL side, the query that is causing high CPU usage on his system. The usage of simple OS tools to find the culprit has been a widely used technique for a long time by PostgreSQL and... by Nickolay Ihalainen | Feb 22, 2018 | Hardware and Storage, Insight for DBAs, Monitoring, MySQL
The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense.Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with Percona... by Yves Trudeau | Dec 7, 2017 | Hardware and Storage, Insight for DBAs, MySQL, Percona Software
This post is a hands-on look at ZFS with MySQL.In my previous post, I highlighted the similarities between MySQL and ZFS. Before going any further, I’d like you to be able to play and experiment with ZFS. This post shows you how to configure ZFS with MySQL in a... by Dave Avery | Sep 18, 2017 | Monitoring, Percona Software, Webinars
Join Percona’s, Principal Support Engineer, Markus Albe as he presents A Percona Support Engineer Walkthrough for pt-stalk on Tuesday, September 19, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register NowAs a support engineer, I get dozens of pt-stalk captures... by Peter Zaitsev | Aug 28, 2017 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL
In this blog post, I will look at disk utilization and saturation.In my previous blog post, I wrote about CPU utilization and saturation, the practical difference between them and how different CPU utilization and saturation impact response times. Now we will... by Tim Vaillancourt | Mar 10, 2017 | MongoDB, Percona Software
by Sveta Smirnova | Mar 1, 2017 | MySQL, Open Source
In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results.The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I... by Vadim Tkachenko | Nov 16, 2015 | Cloud, MySQL
Recently my colleague (by Percona) Yves Trudeau and colleague (by industry) Marco Tusa published their materials on Amazon Aurora. Indeed, Amazon Aurora is a hot topic these days, and we have a stream of customer inquiries regarding this technology. I’ve... by Muhammad Irfan | Sep 4, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
Here on the Percona Support team we often ask customers to retrieve disk stats to monitor disk IO and to measure block devices iops and latency. There are a number of tools available to monitor IO on Linux. iostat is one of the popular tools and Percona Toolkit, which... by Peter Zaitsev | Jun 3, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Software
I’ve been running a benchmark today on my old test box with conventional hard drives (no raid with BBU) and noticed something unusual in the CPU utilization statistics being reported.The benchmark was run like this: sysbench --num-threads=64 --max-requests=0... by Vadim Tkachenko | May 28, 2014 | Insight for DBAs, MySQL, Percona Software
First, I would like to invite you to my webinar, “this post.Basically our agent allows users to collect ALL MySQL metrics plus important environment’s metrics, like CPU, memory, IO stats.And when I talk all MySQL it is: Metrics from SHOW GLOBAL STATUS (I... by Ryan Lowe | Apr 7, 2014 | Insight for DBAs, 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... by Mike Benshoof | Jun 24, 2013 | Insight for DBAs, MySQL
Statement-based or row-based, or mixed? We’ve all seen this discussed at length so I’m not trying to rehash tired arguments. At a high level, the difference is simple: Statement based replication (SBR) replicates the SQL statements to the slave... by Yves Trudeau | Apr 19, 2013 | Hardware and Storage, Insight for DBAs, MySQL
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex... by Jay Janssen | Nov 26, 2012 | MySQL, Percona Software
I learn more and more about Galera every day. As I learn more, I try to keep my myq_gadgets toolkit up to date with what I consider is important to keep any eye on on a PXC node. In that spirit, I just today pushed some changes to the...