Seagate SSDs: Linux and MySQL TPC-C Optimizations Application Note
■This application note details procedures for setting up Seagate SAS, SATA and NVMe drives in a database infrastructure to achieve optimum performance. Because each organization and deployment environment is unique, there isn't just one way to configure the Seagate SSDs for best results; there are, however, general guidelines and tools available to assist with the effort. This paper addresses some of them. The discussion is specific to Linux, although most of the popular relational and non-relational databases run on many different OSs and work with Seagate SSDs. The paper also discusses tuning and processes that can be applied to environments to increase TPC-C performance when implementing a range of Seagate SSDs.
■The performance-optimization recommendations in this application note center around the following topics:
●Seagate SSD configuration
●Linux OS configuration
●MySQL database configuration
■Many of these optimizations are focused on increasing concurrency, decreasing locks and allowing more physical I/Os to the Seagate SSD. The Oracle MySQL 5.6 INNODB database engine was used for all the tests referenced in this paper.
|
|
Application note & Design Guide |
|
|
|
Please see the document for details |
|
|
|
|
|
|
|
English Chinese Chinese and English Japanese |
|
April 12, 2017 |
|
Rev. C |
|
100813349 |
|
231 KB |
- +1 Like
- Add to Favorites
Recommend
All reproduced articles on this site are for the purpose of conveying more information and clearly indicate the source. If media or individuals who do not want to be reproduced can contact us, which will be deleted.