Benefits Over HDDs Include Major Performance Improvements, Server Consolidation and Reduced Power Consumption
If you’re running MySQL or any relational database for that matter, you know how critical fast data access is. The catch, however, is that MySQL database performance is only as good as the hardware it relies on. If your storage is slow, database response times and access to data will be sluggish resulting in unhappy users.
Hard disk drives (HDDs) are still used for databases today, however, even with fast interfaces like SAS, these drives are limited by mechanical parts and spinning read/write heads that result in high latency and low throughput. Given the storage and data access demands of modern MySQL databases, HDD performance simply cannot keep pace. If you want to jumpstart your modern and data-intensive MySQL databases, you need storage that can keep up.
KIOXIA RM7 Series Value SAS SSDs are a great solution for storage that can keep up with increasing storage demands and deliver dramatically faster performance than traditional HDDs without breaking the bank. And, better yet, they are drop-in replacements for your 2.5-inch1 enterprise SAS HDDs with minimal disruption to your IT operations, so you can upgrade your MySQL servers without shutting them down.
The Numbers Speak for Themselves
We ran a series of performance tests comparing KIOXIA RM7-R Series Value SAS SSDs to enterprise SAS HDDs from a leading vendor, both in 2.5-inch form factors. An HPE ProLiant DL380 Gen11 server was used to run HammerDB2 benchmarking application that simulated MySQL workloads. Here’s an example of what you can expect3 if you upgrade your enterprise SAS HDDs to KIOXIA RM7-R Series Value SAS SSDs:
- 36x higher transactions per minute (TPM)
- 24x higher TPM per watt
- 5x higher CPU utilization
- 36x higher read throughput
- 17x higher write throughput
- 122x lower read latency
- 10x lower write latency
- 10x to 49x lower workload latency (depending on the transaction)
The data tells us that replacing your enterprise SAS HDDs with KIOXIA RM7-R Series Value SAS SSDs can greatly improve your MySQL server’s performance. Depending on the workload specifics, a single system with these value SAS drives will be able to outperform 10 or more systems running enterprise SAS HDDs. This allows you to consolidate the rack space that those SAS HDD servers occupy, freeing up power and rack space for systems to run different applications.
KIOXIA RM7 Series Value SAS SSDs can be easily swapped with enterprise SAS HDDs and can lead to server consolidation and rack density increases. Coupled with higher TPM, higher read throughput and lower drive and database workload latencies, these value SAS SSDs delivered significantly faster response times and better end user experiences. The complete test comparisons are available here.
Final Thoughts
If you’re using enterprise SAS HDDs for MySQL databases which may exhibit application or system performance lags, or an underutilization of CPU or memory resources, it’s probably time to make a switch to KIOXIA RM7 Series Value SAS SSDs. With this cost-effective upgrade, your MySQL servers can be consolidated, freeing up rack space and power for other emerging workloads.
Don’t let outdated HDD storage hold back your MySQL database applications. Make the switch to KIOXIA RM7 Series Value SAS SSDs and experience these major improvements yourself.
NOTES:
1 2.5-inch indicates the form factor of the SSD and not its physical size.
2 HammerDB is benchmarking and load testing software that is used to test popular databases. It simulates the stored workloads of multiple virtual users against specific databases to identify transactional scenarios and derive meaningful information about the data environment, such as performance comparisons.
3 Read and write speed may vary depending on the host device, read and write conditions and file size.
TRADEMARKS:
HPE and ProLiant are registered trademarks of Hewlett-Packard Enterprise Company and/or its affiliates. MySQL is a registered trademark of Oracle and/or its affiliates. All other company names, product names and service names may be trademarks or registered trademarks of third-party companies.
DISCLAIMERS:
KIOXIA America, Inc. may make changes to specifications and product descriptions at any time. The information presented in this blog is for informational purposes only and may contain technical inaccuracies, omissions and typographical errors. Any performance tests and ratings are measured using systems that reflect the approximate performance of KIOXIA America, Inc. products as measured by those tests. In no event will KIOXIA America, Inc. be liable to any person for any direct, indirect, special or other consequential damages arising from the use of any information contained herein, even if KIOXIA America, Inc. are advised of the possibility of such damages.