[root@Gaggle ric]# tail -f /tmp/mysql_query.log
/usr/sbin/mysqld, Version: 5.0.22-standard-log. started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
061215 19:42:54 1 Connect gaggle@localhost on smlive
1 Query SET NAMES utf8
1 Query SET character_set_results = NULL
1 Query SHOW VARIABLES
1 Query SHOW COLLATION
1 Query SET autocommit=1
2 Connect gaggle@localhost on smlive
2 Query SET NAMES utf8
2 Query SET character_set_results = NULL
2 Query SHOW VARIABLES
2 Query SHOW COLLATION
2 Query SET autocommit=1
1 Query SELECT 1
2 Query USE `smlive`
1 Query SHOW VARIABLES LIKE 'tx_isolation'
2 Query SHOW VARIABLES LIKE 'tx_isolation'
2 Query SET autocommit=1
1 Query SHOW VARIABLES LIKE 'tx_isolation'
2 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
2 Query select userid, groupid from users where username = 'sys_admin' and domainid = 0
1 Query USE `smlive`
2 Query SHOW VARIABLES LIKE 'tx_isolation'
1 Query SHOW VARIABLES LIKE 'tx_isolation'