AWS某些instance有提供SSD,下面是使用m3.medium,並且將MySQL安裝在SSD上面的測試數據
[root@ip-172-31-17-67 ssd]# time sysbench --test=oltp --mysql-table-engine=innodb --mysql-user=$dbUser --mysql-password=$dbPassword --db-driver=mysql --mysql-db=test --oltp-table-size=1000000 --oltp-table-name=t1 --oltp-nontrx-mode=insert --mysql-socket=/mnt/ssd/mysql/mysql.sock run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Maximum number of requests for OLTP test is limited to 10000 Threads started! Done. OLTP test statistics: queries performed: read: 140000 write: 50000 other: 20000 total: 210000 transactions: 10000 (169.49 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 190000 (3220.29 per sec.) other operations: 20000 (338.98 per sec.) Test execution summary: total time: 59.0009s total number of events: 10000 total time taken by event execution: 58.8980 per-request statistics: min: 2.65ms avg: 5.89ms max: 111.90ms approx. 95 percentile: 15.02ms Threads fairness: events (avg/stddev): 10000.0000/0.00 execution time (avg/stddev): 58.8980/0.00 real 0m59.107s user 0m4.027s sys 0m9.246s