Threadpool Performance Assessment - MySQL vs Mariadb
Why this assessment of mysql vs mariadb threadpool Threadpool is a commercial feature in MySQL whereas it's opensource in Mariadb and some variation is there so, I thought of assessing to know real gain of threadpool in terms of performance. This performance assessment, I did on on my 6 core ubuntu 24 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 have taken latest build of MySQL commnunity 9.7.0 and Mariadb 13.0.1 . 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. Findings and observations In the point-select test, MariaDB shows a performance drop...