-- 查看當(dāng)前狀態(tài)
SHOW VARIABLES LIKE 'general_log%';

-- 啟用通用查詢?nèi)罩?
SET GLOBAL general_log = 'ON';

-- 設(shè)置日志文件路徑（可選）
SET GLOBAL general_log_file = '/var/log/mysql/mysql-general.log';

cat /var/log/mysql/mysql-general.log

-- 查看是否啟用
SHOW VARIABLES LIKE 'log_bin';

-- 查看所有二進(jìn)制日志文件
SHOW BINARY LOGS;

-- 查看特定二進(jìn)制日志內(nèi)容
SHOW BINLOG EVENTS IN 'mysql-bin.000001';

mysqlbinlog /var/lib/mysql/mysql-bin.000001

-- 查看當(dāng)前狀態(tài)
SHOW VARIABLES LIKE 'slow_query%';

-- 啟用慢查詢?nèi)罩?
SET GLOBAL slow_query_log = 'ON';

-- 設(shè)置慢查詢閾值（秒）
SET GLOBAL long_query_time = 2;

-- 設(shè)置日志文件路徑
SET GLOBAL slow_query_log_file = '/var/log/mysql/mysql-slow.log';

INSTALL PLUGIN audit_log SONAME 'audit_log.so';

-- 查看當(dāng)前會話<a  rel="external nofollow"   target="_blank">執(zhí)行</a>過的SQL
SELECT * FROM performance_schema.events_statements_history
WHERE thread_id = PS_CURRENT_THREAD_ID();

-- 查看最近執(zhí)行的語句
SELECT * FROM performance_schema.events_statements_history_long
ORDER BY EVENT_ID DESC LIMIT 10;

-- 查看連接歷史
SELECT * FROM performance_schema.events_waits_history_long
WHERE EVENT_NAME LIKE 'wait/io/socket%';

cat ~/.mysql_history