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

22/02/2019 0 Comments

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.

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