TPS report

Drupal scalability, Part 3

We were finally able to upgrade the database server disks last September before the frenzy of PCI compliance consumed everyone's spare cycles. The old configuration was a three disk RAID 5 array, new configuration is a six disk RAID 10 array using 15k RPM disks. I finally got to write a TPS report:

OLD: 90-100 TPS
NEW: 400-415 TPS sustained, ~800 TPS peak
===

So we're at about 400 writes per second, up from 90. To make fair comparisons I stuck with the same simple tests with ApacheBench.