Right way to tune up innodb_thread_concurrency in mysql 5.7

haancruic1998 — Fri, 17 Jul 2020 06:31:04 GMT

I'm in a plan to increase thread concurrency in my production MySQL server 5.7 but not sure, before what are the params/configurations that need to be measured and configured to increase the thread concurrency to the right optimal value. When checked with the MySQL official documentation, there seems to be a note stating

Occasionally, There seems to be a sudden increase in overall thread usage by slow queries and all 8 threads were under operation resulting in making normal running queries to get slowed down :(

Hence what's the right way to tune up with thread concurrency?

Re: Right way to tune up innodb_thread_concurrency in mysql 5.7

haancruic1998 — Sat, 18 Jul 2020 03:39:28 GMT

There is a way. You edit the source code of the application.

blender gimp audacity

topic Right way to tune up innodb_thread_concurrency in mysql 5.7 in Integration and Testing

Right way to tune up innodb_thread_concurrency in mysql 5.7

Re: Right way to tune up innodb_thread_concurrency in mysql 5.7