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


HowTo: Enable Remote Connections to MySQL

Open the the MySQL configuration file: nano /etc/mysql/my.cnf and comment out the following line, save the file and then restart the MySQL service. #bind-address = 127.0.0.1 Restart the MySQL service. service mysql restart OR you can run the following command to comment out the same line and then restart the MySQL service. sed -i ‘s/^bind-address.*/#bind-address […]

Read More