【讨论】有没有修改配置参数后不重启MySQL服务的方法？

freewatersb

看过一篇讲不重启修改参数配置的,只是记录下了方法,链接找不到了.

在线修改mysql的系统变量：

mysql> show variables like 'log_slave_updates';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| log_slave_updates | ON    |
+-------------------+-------+
1 row in set (0.00 sec)



mysql> set global log_slave_updates=0;                                       
ERROR 1193 (HY000): Unknown system variable 'log_slave_updates'


mysql>  system gdb -p $(pidof mysqld) -ex "set opt_log_slave_updates=0" -batch
Excess command line arguments ignored. (9922 ...)
19885: No such file or directory.
(no debugging symbols found)
Using host libthread_db library "/lib64/libthread_db.so.1".
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
[Thread debugging using libthread_db enabled]
[New Thread 47873757603968 (LWP 12328)]
[New Thread 1166383424 (LWP 12341)]
[New Thread 1166117184 (LWP 12339)]
[New Thread 1092294976 (LWP 12338)]
[New Thread 1165850944 (LWP 12337)]
[New Thread 1155361088 (LWP 12336)]
[New Thread 1144871232 (LWP 12335)]
[New Thread 1134381376 (LWP 12333)]
[New Thread 1123891520 (LWP 12332)]
[New Thread 1113401664 (LWP 12331)]
[New Thread 1102911808 (LWP 12330)]
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
0x00000039314cb332 in select () from /lib64/libc.so.6


mysql> show variables like 'log_slave_updates';                                       
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| log_slave_updates | OFF   |
+-------------------+-------+
1 row in set (0.00 sec)