database performance: FreeBSD vs Linux vs Solaris: Multi-Threaded Delete
Multi-Threaded Delete 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,
with FreeBSD scaling more linearily:
PostgreSQL
Because of insufficient data, we cannot report on PostgreSQL. This page will be updated when the data becomes available.
