MySQL performance: Sysbench complex test
Now it is time to go ahead with some more heavy SQL test. The Sysbench complex is a test with, err, complex statement and mixed read and write requests. I run this test with 16 threads asking for a total of 10000 requests (1/10 that the simple test).
Some number in transactions per second:
In the heavily threaded MySQL program, Xen is again the slowest machine by a very wide margin, while the others are more or less on par.
What about CPU load?
VMware is the “lightest” hypervisor, probably thanks to its paravirtualized network driver and low disk write CPU load (see the IOMeter results above).
Apropos of disks, the next graph is very interesting:
KVM seems to be the hypervisor less heavy on disk subsystems. Don't be fooled by relatively good Xen results: its low load is probably only a results of its bad number of transaction per second.
UPDATE: a recent article comparing KVM vs VirtualBox can be found here: http://www.ilsistemista.net/index.php/virtualization/12-kvm-vs-virtualbox-40-on-rhel-6.html