Hi, all
I write a patch to show physical & logical IO statistics in slow log. Now it
only support XtraDB storage engine, but it is easy to realize in other engine.
You may found it like this in slow log:
# Time: 111227 16:29:54
# User@Host: root[root] @ localhost [::1]
# Query_time: 0.310018 Lock_time: 0.203012 Rows_sent: 1 Rows_examined: 30000
Logical_IO: 30145 Physical_IO: 50
use tpcc;
SET timestamp=1324974594;
select count(1) from history;
I think this feature is much helpful for DBA or Developer to know what the real
IO one SQL has. In addition, it is simple, only a few changes should be made.
The branch is: https://code.launchpad.net/~jiangchengyao/+junk/mariadb
Regards,
David
2011-12-30
jiangchengyao
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
