mysql sql 跟踪_mysql跟踪每个操作执行sql语句情况

最近在做一个phpwind的插件,但是对phpwind也不是太熟悉,更可恶的是phpwind团队写的php代码是真看不了.太多弯弯绕了,找来找去,都找晕了.索性朝mysql下手吧,插件功能是往phpwind发一新贴看看都改动了哪些表,网上找了一大通也没有找到合适的.

最后找来个my.ini的配置文件说明看了看偶然发现简单设置就可以

在my.ini 或my.cnf里面添加如下设置.重启mysql

[mysqld]

log=E:/MySQL5.1/my.log

log-output=FILE

看下log文件记录

Time                 Id Command    Argument

100331 10:46:16    1 Connect on

1 Query SET character_set_connection=gbk,character_set_results=gbk,character_set_client=binary

1 Query SET sql_mode=''

1 Init DB phpwind

100331 10:46:17    1 Query SELECT uid,username,password,safecv,email,regdate FROM pw_members WHERE username= 'admin'

1 Query SELECT * FROM pw_ucapp

1 Query SELECT m.uid,m.username,m.password,m.safecv,m.groupid,m.memberid,m.yz,md.onlineip, md.postnum,md.rvrc,md.money,md.credit,md.currency,md.lastpost,md.onlinetime,md.todaypost,md.monthpost FROM pw_members m LEFT JOIN pw_memberdata md ON md.uid=m.uid WHERE m.uid= '1' AND m.groupid<>'0' AND md.uid IS NOT NULL

1 Query SELECT cid,value FROM pw_membercredit WHERE uid= '1'

1 Query REPLACE INTO pw_elements(type,mark,id,value,addition,time) VALUES ('usersort','money','1','6','admin','1270003576') , ('usersort','rvrc','1','2','admin','1270003576') , ('usersort','monthpost','1','5','admin','1270003576') , ('usersort','postnum','1','6','admin','1270003576')

1 Query SELECT * FROM pw_elements WHERE type='usersort' AND mark IN ('money','rvrc','monthpost','postnum') ORDER BY mark,value DESC

1 Query UPDATE pw_memberdata SET monoltime=IF(lastvisit

100331 10:46:18    1 Quit

------------------------------------------------------------------------------------------------------

哈哈太清楚了.