Thread: How to reload mysql configuration without restart mysqld daemon?

Hi everybody

I want to add slow_query log in mysql> terminal

mysql> set GLOBAL slow_query_log=ON;
mysql> show variables like '%slow%';
mysql> show variables like '%slow%';
+---------------------+--------------------------------+
| Variable_name | Value |
+---------------------+--------------------------------+
| log_slow_queries | ON |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | /var/lib/mysql/ubungu-slow.log |
+---------------------+--------------------------------+

how can I affect that change without restart mysqld daemon

Try the following for all user related changes i.e. add /remove /modify privileges for your user

Code:

FLUSH PRIVILEGES;

I want to add slow_query log in mysql> terminal
how can I affect that change without restart mysqld daemon

Those changes are instant. However, if you reboot the server or restart the mysql server, changes will be lost. So you need to edit the /etc/my.cnf. Add slow query related changes and reload the mysql server using service command. Example my.cnf:

Code:

log_slow_queries       = /var/log/mysql/mysql-slow.log
long_query_time = 2

Reload mysql:

Code:

service mysql reload

The location of my.cnf and service name may change according to the Linux distro.

thank you very much

Originally Posted by phanmemseo

thank you very much

Please Help with the tips to reload configuration file my.cnf without restarting the service.