by Sergey Pronin | Jun 11, 2025 | Cloud, Percona Software, PostgreSQL
This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring its original perspective. Running PostgreSQL on Kubernetes promises flexibility, but storage decisions can quickly make or...
by Tibor Korocz | Aug 6, 2020 | Benchmarks, MySQL, Percona Software
Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity. First of all, why do we need another storage...
by Yves Trudeau | Dec 18, 2019 | Insight for DBAs, MySQL, Storage Engine
The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this variable based on the top IO write specifications of their storage. Is this a correct choice? Is it an...
by Yves Trudeau | Feb 8, 2018 | Hardware and Storage, Insight for DBAs, MySQL
While preparing a post on the design of ZFS based servers for use with MySQL, I stumbled on the topic of fsync call performance. The fsync call is very expensive, but it is essential to databases as it allows for durability (the “D” of the ACID acronym)....
by Peter Zaitsev | Jan 8, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at how ioping can be used with other tools to understand and troubleshoot storage performance, specifically as it relates to MySQL workloads. I recently ran into ioping, a nice little utility by Konstantin Khlebnikov that checks storage...
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 look at...
by Peter Zaitsev | Jun 9, 2017 | Cloud, Insight for DBAs, Monitoring, MySQL
In this blog, we will provide answers to the Q & A for the MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling webinar. First, we want to thank everybody for attending the June 7, 2017 webinar. The recording and slides for the webinar are...
by Peter Zaitsev | Mar 22, 2017 | Benchmarks, Hardware and Storage, MySQL
In this blog post, I’ll take a look at the performance of the Samsung 960 Pro SSD NVME. First, I know the Samsung 960 Pro is a consumer SSD NVME drive, not intended for sustained data center workloads. But the AnandTech review looked good enough that I...
by Peter Zaitsev | Feb 9, 2017 | Hardware and Storage, Insight for DBAs, MongoDB, MySQL
In this blog post, I’ll look at the types of NVMe flash health information you can get from using the NVMe command line tools. Checking SATA-based drive health is easy. Whether it’s an SSD or older spinning drive, you can use the smartctl command to get a...
by Pablo Padua | Jan 10, 2017 | Insight for DBAs, MySQL
In this blog post we’ll look at how to move a MySQL partition from one table to another, for MySQL versions before 5.7. Up to version 5.7, MySQL had a limitation that made it impossible to directly exchange partitions between partitioned tables. Now and then, we...
by Peter Zaitsev | Sep 9, 2016 | MySQL
This blog post discussed the advantages of SSDs over HDDs for database environments. For years now, I’ve been telling audiences for my MySQL Performance talk the following: if you are running an I/O-intensive database on spinning disks you’re doing it wrong. But there...
by Vadim Tkachenko | Jul 26, 2016 | Benchmarks, MySQL
This blog post will detail the results of Samsung storage in tpcc-mysql benchmark using Percona Server. I had an opportunity to test different Samsung storage devices under tpcc-mysql benchmark powered by Percona Server 5.7. You can find a summary with details...
by Tom Diederich | Aug 13, 2015 | MySQL, Percona Events, Percona Live
Storage. Everyone needs it. Whether your data is in MySQL, a NoSQL, or somewhere in the cloud, with ever-growing data volumes – along with the need for SSDs to cut latency and replication to provide insurance – an organization’s storage footprint is an...
by Peter Zaitsev | May 28, 2015 | MongoDB
If you can make it to Manhattan next Monday, please join me at the MongoDB Community Open House. The June 1 event is free and open to all. It runs from 3:30-6:30 p.m. just across the road from MongoDB World. The MongoDB Community Open House, held at the New York...
