database performance: FreeBSD vs Linux vs Solaris: Multi-Threaded Insert
Multi-Threaded Insert Performance
MySQL
With up to 100 threads and no thread delay, Solaris comes out on top with FreeBSD and Linux are neck and neck:
Adding a 1 millisecond delay in each thread allows for higher throughput and Linux beats Solaris (the full FreeBSD data is still pending):
With many more threads (and a 5 millisecond delay), Solaris failed after 500 threads. Linux and FreeBSD are very close:
PostgreSQL
With up to 100 threads and no thread delay, Solaris beats Linux (the full FreeBSD data is still pending):