Tag - Storage

Fsync Performance on Storage Devices

fsync

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).
Let’s first review the type of disk IO operations […]

Read more

Using ioping to Evaluate Storage Performance for MySQL Workloads

ioping

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 latency.  
For me, the main beauty of ioping is its simplicity and […]

Read more

Looking at Disk Utilization and Saturation

DIsk Utilization and Saturation small

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 another critical component of database performance: the storage subsystem. In this post, I […]

Read more

Q & A: MySQL In the Cloud – Migration, Best Practices, High Availability, Scaling

MySQL in the Cloud

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 available here. Below is the list of your questions that we […]

Read more

The Puzzling Performance of the Samsung 960 Pro

samsung 960 pro small

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 decided to take it for a test spin to see if […]

Read more

Using NVMe Command Line Tools to Check NVMe Flash Health

NVMe Flash Health

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 wealth of information about the device’s performance and health. […]

Read more

How to Move a MySQL Partition from One Table to Another

Move a MySQL Partition

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 get questions about how to import an .ibd for use […]

Read more

Don’t Spin Your Data, Use SSDs!

ssds

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 are still a surprising number of laggards who aren’t embracing SSD storage […]

Read more

Testing Samsung storage in tpcc-mysql benchmark of Percona Server

tpcc-mysql benchmark

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 here https://github.com/Percona-Lab-results/201607-tpcc-samsung-storage/blob/master/summary-tpcc-samsung.md
I have in my possession:

Samsung 850 Pro, 2TB: This is a SATA device and is positioned […]

Read more

The language of compression

Leif Walsh will talk about the language of compression at Percona Live Amsterdam
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 […]

Read more