希望能够跟踪会话。 我知道SHOW FULL PROCESSLIST; 和select * from information_schema.processlist能够察看会话正在执行什么sql,但是我想看到历史。 比如oracle中可以通过查看当前会话打开了哪些cursor,也可以查看sga的状态,还可以查看log。 但是在mySql中怎么办?
D:\Program Files\MySQL\MySQL Server 5.2\bin\mysqld-nt, Version: 5.2.0-falcon-alpha-community-nt-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
D:\Program Files\MySQL\MySQL Server 5.2\bin\mysqld-nt, Version: 5.2.0-falcon-alpha-community-nt-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument