database performance: FreeBSD vs Linux vs Solaris: Multi-Threaded Update
Multi-Threaded Update Performance
MySQL
With up to 100 threads and no thread delay, Solaris comes out on top, FreeBSD and Linux are neck and neck:
Adding a 1 millisecond delay in each thread allows for higher throughput and Linux beats Solaris (the FreeBSD test stopped):
With many more threads (and a 5 millisecond delay), Solaris failed after 500 threads.
Linux is showing a performance blip at 850 threads (which may be due to other system activity) but otherwise ahead of FreeBSD:
PostgreSQL
Because of insufficient data, we cannot report on PostgreSQL. This page will be updated when the data becomes available.
