Databases Reference
In-Depth Information
Figure 13-1. SysBench read-only benchmarks for MySQL in the AWS cloud
The results should not be surprising, given the workload and the hardware. For exam-
ple, the largest EC2 instance tops out at eight threads, because it has eight CPU cores.
(A read/write workload would spend some of its time off-CPU doing I/O, so we would
be able to achieve more than eight threads of effective concurrency.) This chart might
lead you to assume that the Cisco's advantage is in CPU power, which is what we
thought. So we benchmarked raw CPU performance to find out, using SysBench's
prime-number benchmark.
Figure 13-2
shows the results.
Figure 13-2. SysBench CPU prime-number benchmarks for AWS servers
The Cisco server has lower per-CPU performance than the EC2 servers. Surprised? We
were a bit surprised ourselves. The prime-number benchmark is essentially raw CPU
