database performance: FreeBSD vs Linux vs Solaris: Multi-Threaded Combined Test
Multi-Threaded Combined Performance (Select + Update + Insert + Delete)
MySQL
With up to 100 threads and a 50 milliseconds delay:
With a 20 milliseconds delay in each thread:
With a 10 milliseconds delay in each thread:
With many more threads and a 5 millisecond delay in each thread (Solaris fails again, at around 500 threads):
A second run produced the same results. (Note that the
number of threads displayed must be multiplied by 4 to take account of each operation: select, update, delete, insert)
The results for Solaris looked promising from the first batch, but the winner of this test has to be FreeBSD, as it consistently outperforms Linux.
PostgreSQL
With up to 100 threads and a 20 milliseconds delay, there is no clear winner:
But with many more threads and a 5 millisecond delay in each thread (Solaris fails with around 500 threads,
and FreeBSD with a few more):
The number of threads must be multiplied by 4 (one for each of update, delele, select, insert)
