使用pt-ioprofile对MySQL作IO剖析

使用pt-ioprofile对MySQL作IO剖析

[root@mysql1 db_application]# /usr/local/pt-tookit/bin/pt-ioprofile 
Fri Jun 20 17:55:21 CST 2014
Tracing process ID 4565
     total      pread       read     pwrite      write      fsync      lseek filename
  5.724109   0.000000   3.073394   0.000000   1.225703   1.425012   0.000000 /data/mysql/mysql-bin.000231
  2.649129   0.000000   0.000000   1.249857   0.000000   1.399272   0.000000 /data/mysql/ib_logfile1
  0.601329   0.601329   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/otriprecordinfo/odevicetriprecordinfo.ibd
  0.426171   0.426171   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/ogathermessagebase/gathermessagequeue.ibd
  0.316264   0.316264   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/otriprecordinfo/odevicetriprecordnodeinfo.ibd
  0.039654   0.039654   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_application/trip_record_tmp_b.ibd
  0.029006   0.029006   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_application/trip_record_point.ibd
  0.021813   0.021813   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_7/tb_account_0.ibd
  0.020185   0.020185   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_application/warning_history.ibd
  0.014518   0.014518   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_public/public_auth_group.ibd
  0.014227   0.014227   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_public/public_auth.ibd
  0.011955   0.011955   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_application/warning_items.ibd
  0.010153   0.010153   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_6/tb_account_9.ibd
  0.008902   0.008902   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/xmpp0311/stanza.ibd
  0.008895   0.000000   0.000000   0.000000   0.000000   0.000000   0.008895 /tmp/MLmQtal7
  0.008879   0.008879   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_3/tb_account_5.ibd
  0.008431   0.000000   0.000000   0.000000   0.000000   0.000000   0.008431 /tmp/MLFqr6DU
  0.008082   0.008082   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_1/tb_user_0.ibd
  0.007852   0.007852   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_index/uname_index.ibd
  0.007343   0.007343   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_9/tb_account_8.ibd
  0.006462   0.006462   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_1/tb_account_0.ibd
  0.006122   0.006122   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_6/tb_account_2.ibd
  0.004929   0.004929   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/ibdata1
  0.004531   0.004531   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_6/tb_user_9.ibd
  0.003962   0.003962   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_5/tb_user_ext_8.ibd
  0.003637   0.003637   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_9/tb_account_2.ibd
  0.003218   0.003218   0.000000   0.000000   0.000000   0.000000   0.000000 /data/mysql/db_user_9/tb_account_3.ibd
  0.001880   0.000000   0.000000   0.000000   0.001880   0.000000   0.000000 /data/mysql/mysql-slow.log
[root@mysql1 db_application]#