In a previous thread pool post, I mentioned that in Percona Server we used an open source implementation of MariaDB’s thread pool, and enhanced/improved it further. Below I would like to describe some of these improvements for transactional workloads.
When we were evaluating MariaDB’s thread pool implementation, we
observed that it improves scalability for
statements. However, it does not scale well with multi-statement
UPDATE_NO_KEY test which was run
AUTOCOMMIT statement and inside a transaction
gave the following results:
After analysis, we identified the major cause of that inefficiency: …[Read more]