调试mysql

# 进入mysql
mysql -u root -p
# 查看当前状态
show processlist;
# 查看日志配置
SHOW VARIABLES LIKE "general_log%";
# 如果没有开启,ON开启
SET GLOBAL general_log = 'ON';
# 如果查看不到路径请自定义日志文件路劲
SET GLOBAL general_log_file = '/var/log/mysql/general_log.log';
# 实时查看
tail -f /var/lib/mysql/general_sql.log