IT Knowledge Base

Technical Repository

HowTo: MySQL thread_cache_size Tuning

MySQL> SHOW GLOBAL STATUS LIKE ‘Connections’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Connections | 8608 | +—————+——-+ 1 row in set (0.01 sec) MySQL> SHOW GLOBAL STATUS LIKE ‘Threads_created’; +—————–+——-+ | Variable_name | Value | +—————–+——-+ | Threads_created | 102 | +—————–+——-+ 1 row in set (0.00 sec) MySQL> SHOW GLOBAL STATUS LIKE […]

Read More