https://community.developer.cybersource.com/t5/Integration-and-Testing/What-are-the-right-ways-to-analyse-and-tune-up-innodb-thread/m-p/69698#M42676 <P class="_1qeIAgB0cPwnLhDF9XSiJM">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</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">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 :(</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Hence what's the right way to tune up with thread concurrency?</P><P>&nbsp;</P> Thu, 14 Nov 2019 16:14:51 GMT DomnicFernas 2019-11-14T16:14:51Z https://community.developer.cybersource.com/t5/Integration-and-Testing/What-are-the-right-ways-to-analyse-and-tune-up-innodb-thread/m-p/69698#M42676 <P class="_1qeIAgB0cPwnLhDF9XSiJM">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</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">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 :(</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Hence what's the right way to tune up with thread concurrency?</P><P>&nbsp;</P> Thu, 14 Nov 2019 16:14:51 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/What-are-the-right-ways-to-analyse-and-tune-up-innodb-thread/m-p/69698#M42676 DomnicFernas 2019-11-14T16:14:51Z