2021-10-21 mysql执行语句记录监控

• mysql开启日志监控
• java插桩技术

SHOW VARIABLES LIKE "general_log%";

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON'; 

SELECt * ,CONVERT (argument USING utf8) as sqltext from mysql.general_log ORDER BY event_time DESC;
truncate table mysql.general_log;

找到最后执行语句的代码块，打印出最终执行的sql语句
参考：Java 使用插桩技术解决慢查询测试问题
http://testerhome.com/topics/29228