Benchmarking Google Cloud SQL instances

• Number of select transactions executed per second
• Number of insert transactions executed per second
• Number of update transactions executed per second
• InnoDB Disk Reads – MB/s
• InnoDB Disk Reads – MB/s

Testing Methodology

1. 1. All the testing was done with the tpcc-mysql package, with a scale factor of 500 Warehouses.
   2. All testing was done using a Google Compute VM
      • Ubuntu 15.04 machine
      • Specifications: n1-standard-4 - 4 vCPU, 15 GB Memory
      • Zone: us-central1-a
   3. Following Cloud SQL instances were bench-marked:

1. We used 100, 200, 300 and 400 concurrent user sessions (threads).
2. We used a scale factor of 500 warehouses which roughly transforms to 50 GB data in the database.
3. We performed four iterations of tests per instance by varying the number of connections (threads) per run. Tests were performed using the 100, 200, 300 and 400 threads.
4. For each set of user sessions, we performed a half hour-long run, gathering data for new order transactions every 10 seconds.
5. Following data was gathered:
   • Throughout expressed as tpm-C - Orders Processed per Minute
   • Number of select transactions executed per second
   • Number of insert transactions executed per second
   • Number of update transactions executed per second
   • InnoDB Disk Reads – MB/s
   • InnoDB Disk Reads – MB/s

Benchmarking Results - DML Transactions Per Minute

• For 100, 200 and 300 threads db-n1-highmem-16 outperformed the rest by a large margin
• For 400 threads db-n1-highmem-8 and db-n1-highmem-16 performed the similar
• db-n1-standard-8 and db-n1-standard-16 performed the same for all thread counts
• Rest of the instances performed similarly

• For 100, 200 and 300 threads db-n1-highmem-16 outperformed the rest by a large margin
• For 400 threads db-n1-highmem-8 and db-n1-highmem-16 performed same
• db-n1-himem-4, db-n1-standard-8 and db-n1-standard-16 performed the same for all thread counts
• Rest of the instances performed similarly

• For 100, 200 and 300 threads db-n1-highmem-16 outperformed the rest by a large margin
• db-n1-standard-8 and db-n1-standard-16 performed the same for all thread counts
• Rest of the instances performed similarly

Conclusion

• The greatest throughput was achieved at 100 threads
• db-n1-standard-16 (60G) performed very close to db-n1-himem-16 (104G).
• db-n1-himem-8 (52G) performance was appreciably lower than db-n1-standard-16 (60G)
• Google Cloud SQL High Performance instances performed significantly better than currently being offered Google Cloud SQL Standard Class Instances by a scale of 100-200%