If the MySQL has many connects established (i.e. a website without persistent connections), you can improve the performance by setting thread_cache_size to a non-zero value. 16 is a good value to start with. Increase the value until your threads_created do not grow very quickly. - Study24x7
Social learning Network
23 Apr 2019 01:26 PM study24x7 study24x7

If the MySQL has many connects established (i.e. a website without persistent connections), you can improve the performance by setting thread_cache_size to a non-zero value. 16 is a good value to start with. Increase the value until your threads_created do not grow very quickly.

study24x7
Write a comment
Related Questions
500+   more Questions to answer
Most Related Articles