通过show variables like ‘general_log%’可以看查询日志
mysql> show variables like 'general_log%'; +------------------+-----------------------------+ | Variable_name | Value | +------------------+-----------------------------+ | general_log | OFF | | general_log_file | /data1/mysql/monitor-44.log | +------------------+-----------------------------+ 2 rows in set (0.00 sec) mysql> set global general_log=ON; Query OK, 0 rows affected (0.00 sec) mysql> SHOW warnings; Empty set (0.00 sec) mysql> show variables like 'general_log%'; +------------------+-----------------------------+ | Variable_name | Value | +------------------+-----------------------------+ | general_log | ON | | general_log_file | /data1/mysql/monitor-44.log | +------------------+-----------------------------+ 2 rows in set (0.00 sec)
联系方式QQ:326528263 EMAIL:clnking@163.com 网名:bass 分享技术 突破难点 创新思维