MySQL中最近执行的查询的信息

SET GLOBAL log_output = 'TABLE'; SET GLOBAL general_log = 'ON'; SELECT *, CONVERT(argument USING utf8 ) FROM mysql.general_log where argument like '%maxQuantityLimit%' order by event_time desc SHOW FULL PROCESSLIST; 检查Transactions SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;