mysql 查看执行语句日志

-- 查看慢查询日志是否开启
SHOW VARIABLES LIKE 'slow_query_log';

-- 开启慢查询日志
SET GLOBAL slow_query_log = 'ON';

-- 设置慢查询日志文件路径
SET GLOBAL slow_query_log_file = '/var/log/mysql/slow-query.log';

-- 设置慢查询阈值（单位：秒）
SET GLOBAL long_query_time = 2;

tail -f /var/log/mysql/slow-query.log

-- 查看通用查询日志是否开启
SHOW VARIABLES LIKE 'general_log';

-- 开启通用查询日志
SET GLOBAL general_log = 'ON';

-- 设置通用查询日志文件路径
SET GLOBAL general_log_file = '/var/log/mysql/general-query.log';

tail -f /var/log/mysql/general-query.log

mkdir -p /var/log/mysql
touch /var/log/mysql/slow-query.log
touch /var/log/mysql/general-query.log
chown -R mysql:mysql /var/log/mysql

chown mysql:mysql /var/log/mysql/slow-query.log
chown mysql:mysql /var/log/mysql/general-query.log
chmod 644 /var/log/mysql/slow-query.log
chmod 644 /var/log/mysql/general-query.log

#!/bin/bash
LOG_DIR="/var/log/mysql"
DAYS=7

find $LOG_DIR -type f -name "*.log" -mtime +$DAYS -exec rm -f {} \;

crontab -e

0 0 * * * /path/to/your/cleanup_script.sh