Threadpool Performance Assessment - MySQL 9.7.0 vs Mariadb 13.0.1
Why this assessment of MySQL 9.7.0 vs Mariadb 13.0.1 for threadpool MariaDB’s thread pool is open source; MySQL’s requires a commercial license and some variation is there so, I thought of assessing to know the real gain of threadpool in terms of performance. This performance assessment, I did on on my 6 core ubuntu 24.0 laptop for read-only, read-write and tpcc cached workloads. Here, a cached/memory-bound workload means that data fully fits into buffer-pool. Since, threadpool is available in commercial MySQL so, I could not test it and hope it will be opensource like other commercial features were added to 9.7.0 community edition. I took latest build of MySQL commnunity 9.7.0 and Mariadb 13.0.1 to have all recent changes. Summary Threadpool did not have significant impact in case of Mariadb for read/read-write loads. But, threadpool had very good impact in TPCC workload and it showed +400% gain wrt no-TP Mar...