MariaDB-5.5 thread pool performance test_mysql

Performance Testing of MariaDB-5.5 thread pool MariaDB

BitsCN.com

MariaDB-5.5.21-beta is MariaDB's first version that provides brand new thread pool features, Oracle provides a commercial version of the thread pool plug-in MySQL Enterprise edition, but MariaDB provides a wide range of community users with an open source version.

If you do not know the Thread pool, read the Thread pool in MariaDB 5.5 first.

The thread pool is designed to improve the stability of MariaDB servers in high concurrency. For testing and demonstration, we run sysbench oltp ro to test up to 4096 threads for comparing the new pool-of-threads and the traditional thread-per-connection scheduler.

Is the test result:

Test result description:

Sysbench multi-table OLTP, read-only

16 tables with up to 40 million rows of records and 10 GB of data

16G buffer to avoid disk performance impact

Mysqld uses 16 CPU cores and sysbench uses 8 other cores.

Read/write OLTP stress test results will be released soon

You can download the original test result from here: here

BitsCN.com