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


innodb_thread_concurrency = 16

Where 16 is 16 threads!