Mysql thread_cache_size Optimization Method

Mysql tutorial thread_cache_size Optimization Method

In fact, optimization does not play a major role in the database tutorial configuration. Let's look at a set of parameters.

Mysql thread_cache_size default configuration thread_cache_size = 8

The recommended parameter thread_cache_size is determined by the memory size. When the memory is greater than 3g, it is set to 64
I want to know why we cannot set more. Our application concurrency is greater than 500. If thread_cache_size is set to 500

Setting Method

Optimization Method:

1. mysql> set global thread_cache_size = 16

2. edit/etc/my. cnf to change/Add