How to limit CPU threads with innodb (mysql/mariadb)

Standard

In my.cnf (commom path is /etc/my.cnf) add this line in [mysqld] session:


innodb_thread_concurrency = 16

Where 16 is 16 threads!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.