RDS instance details
- sysbench seeded 100Gb database and then snapshotted
- 1Tb of RDS storage for the database
- RDS MySQL 5.5.27
- Default my.cnf RDS configuration except (find the full 'show
global variables' output at the end of this post)
- performance_schema is enabled
- innodb_flush_logs_at_trx_commit = 0
- provisioning an RDS instance for each instance size / PIOPS configuration from the seeded database. (10 in total)
Test details
- Amazon RDS
- Within an AWS VPC
- US-East
First warm up innodb by running sysbench with options
- oltp table size 1000000000
- max-requests 0
- max-time 300 (5 minute warm up)
- oltp test mode complex
- oltp index …