4. BestConfig for MySQL¶
4.1. Experimental Settings¶
We executed Bestconfig for the MySQL system, and we applied sysbench to test the performance of MySQL. All nodes used in our experiment are shown below.
| Node | OS | CPU | Memory |
|---|---|---|---|
| MySQL | CentOS | 16 Intel(R) Xeon(R) CPU E5620 @ 2.40GHz | 32GB |
| Sysbench | CentOS | 16 Intel(R) Xeon(R) CPU E5620 @ 2.40GHz | 32GB |
4.2. Performance Surface¶
We use Sysbench that is a widely adopted benchmark tools in the workload generator for MySQL to generate the target workload. Currently, the test type in our experiment is oltp and the test mode is simple, and we set num-threads to 16, oltp-table-size to 10000000, and max-time to 300. Figure 1 is the scatter plot of performance for MySQL under OLTP simple test mode.
The scatter plot of performance for MySQL under OLTP simple test mode
4.3. Test Results¶
The result of MySQL under the zipfian read-write workload MySQL_zipfian_readwrite.arff. The result of MySQL under OLTP simple test mode MySQL_OLTP_simple.arff.
4.4. Interface Impl¶
The source files of MySQLConfigReadin and MySQLConfigWrite implement the interfaces of ConfigReadin and ConfigWrite respectively.