安装并使用pt-ioprofile
|
0 1 2 3 4 5 6 7 |
yum install perl-IO-Socket-SSL perl-DBD-MySQL perl-Time-HiRes strace prel prel-devel -y wget https://www.percona.com/downloads/percona-toolkit/3.0.3/source/tarball/percona-toolkit-3.0.3.tar.gz tar zxf percona-toolkit-3.0.3.tar.gz cd percona-toolkit-3.0.3 perl Makefile.PL PREFIX=/opt/percona-toolkit-3.0.3 make make install ./pt-ioprofile --help |
|
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 |
./pt-ioprofile --profile-pid=2591 Fri Jun 16 10:14:36 CST 2017 Tracing process ID 2591 total read pwrite write fdatasync fsync lseek filename 10.392615 0.000000 0.285291 0.000000 0.000000 10.107324 0.000000 /data/3306/data/ib_logfile0 9.396781 0.000000 0.266456 0.000000 0.000000 9.130325 0.000000 /data/3306/data/ib_logfile1 0.813267 0.000000 0.022004 0.000000 0.000000 0.791263 0.000000 /data/3306/data/ibdata1 0.606424 0.011663 0.000000 0.015260 0.579501 0.000000 0.000000 /data/3306/sql_log/mysql-bin.000051 0.100241 0.019795 0.000000 0.062624 0.000000 0.000000 0.017822 /data/3306/sql_log/relay-bin.000097 0.052162 0.000000 0.000000 0.000000 0.000000 0.052162 0.000000 /data/3306/data/jsp_front/log.ibd 0.037788 0.000000 0.000000 0.000000 0.000000 0.037788 0.000000 /data/3306/data/jsp/operation_journal.ibd 0.020805 0.000000 0.000000 0.000000 0.000000 0.000000 0.020805 /tmp/MLo4hDwy 0.019884 0.000000 0.000000 0.000000 0.000000 0.019884 0.000000 /data/3306/data/jsp/app_request_log.ibd 0.018027 0.000000 0.000000 0.000000 0.000000 0.018027 0.000000 /data/3306/data/mysql/slave_relay_log_info.ibd 0.014366 0.000000 0.000000 0.000000 0.000000 0.014366 0.000000 /data/3306/data/mysql/gtid_executed.ibd 0.010841 0.000000 0.000000 0.000000 0.000000 0.010841 0.000000 /data/3306/data/jsp/user_login_log.ibd 0.010423 0.000000 0.000000 0.000000 0.000000 0.010423 0.000000 /data/3306/data/jsp/notify_record.ibd 0.009820 0.000000 0.000000 0.000000 0.000000 0.009820 0.000000 /data/3306/data/jsp_internal/dw_credit.ibd 0.003657 0.000000 0.000000 0.000000 0.000000 0.003657 0.000000 /data/3306/data/mysql/innodb_index_stats.ibd 0.002419 0.000000 0.000000 0.000000 0.000000 0.002419 0.000000 /data/3306/data/jsp/message_received.ibd 0.002410 0.000000 0.000000 0.000000 0.000000 0.002410 0.000000 /data/3306/data/jsp/message_info.ibd 0.002253 0.000000 0.000000 0.000000 0.000000 0.002253 0.000000 /data/3306/data/mysql/innodb_table_stats.ibd 0.001967 0.000000 0.000000 0.000000 0.000000 0.001967 0.000000 /data/3306/data/jsp/user_relation.ibd 0.001770 0.000000 0.000000 0.000000 0.000000 0.001770 0.000000 /data/3306/data/jsp_internal/dw_notice.ibd 0.001697 0.000000 0.000000 0.000000 0.000000 0.001697 0.000000 /data/3306/data/jsp/user_base_info.ibd 0.001658 0.000000 0.000000 0.000000 0.000000 0.001658 0.000000 /data/3306/data/jsp_internal/dw_account.ibd 0.001532 0.000000 0.000000 0.000000 0.000000 0.001532 0.000000 /data/3306/data/jsp_internal/dw_user_amount.ibd 0.001350 0.000000 0.000000 0.000000 0.000000 0.001350 0.000000 /data/3306/data/jsp/user_role.ibd 0.001345 0.000000 0.000000 0.000000 0.000000 0.001345 0.000000 /data/3306/data/jsp/gift_money_trade.ibd 0.001262 0.000000 0.000000 0.000000 0.000000 0.001262 0.000000 /data/3306/data/jsp_internal/dw_userinfo.ibd 0.001205 0.000000 0.000000 0.000000 0.000000 0.001205 0.000000 /data/3306/data/jsp_internal/dw_user.ibd 0.001102 0.000000 0.000000 0.000000 0.000000 0.001102 0.000000 /data/3306/data/jsp/app_equipment_login.ibd 0.001099 0.000000 0.000000 0.000000 0.000000 0.001099 0.000000 /data/3306/data/jsp/user.ibd 0.000888 0.000000 0.000000 0.000000 0.000000 0.000888 0.000000 /data/3306/data/jsp/gift_money.ibd 0.000875 0.000000 0.000000 0.000000 0.000000 0.000875 0.000000 /data/3306/data/jsp/personal_info.ibd 0.000783 0.000000 0.000000 0.000000 0.000000 0.000783 0.000000 /data/3306/data/jsp_internal/dw_user_cache.ibd 0.000777 0.000000 0.000000 0.000000 0.000000 0.000777 0.000000 /data/3306/data/jsp_internal/dw_borrow_auto.ibd ./pt-ioprofile --profile-pid=2591 --cell=sizes Fri Jun 16 10:21:43 CST 2017 Tracing process ID 2591 total read pwrite write fdatasync fsync lseek filename 13142177453 139965 0 139965 0 0 13141897523 /data/3306/sql_log/relay-bin.000097 74807808 0 74807808 0 0 0 0 /data/3306/data/ib_logfile1 72246272 0 72246272 0 0 0 0 /data/3306/data/ib_logfile0 51462144 0 51462144 0 0 0 0 /data/3306/data/ibdata1 277382 138691 0 138691 0 0 0 /data/3306/sql_log/mysql-bin.000051 130325 0 0 0 0 0 130325 /tmp/MLo4hDwy 0 0 0 0 0 0 0 /data/3306/data/mysql/slave_relay_log_info.ibd 0 0 0 0 0 0 0 /data/3306/data/mysql/innodb_table_stats.ibd 0 0 0 0 0 0 0 /data/3306/data/mysql/innodb_index_stats.ibd 0 0 0 0 0 0 0 /data/3306/data/mysql/gtid_executed.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_role.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_relation.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_login_log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_base_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/personal_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/operation_journal.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/message_received.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/message_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_userinfo.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user_cache.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user_amount.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_notice.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_credit.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_borrow_auto.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_account.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/gift_money_trade.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/gift_money.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_front/log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/app_request_log.ibd |
watch -n 1 /opt/percona-toolkit-3.0.3/bin/pt-ioprofile --profile-pid=2591 --cell=sizes --run-time=1
正常后：
|
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 |
/opt/percona-toolkit-3.0.3/bin/pt-ioprofile --profile-pid=11111 --cell=sizes Fri Jun 16 12:40:28 CST 2017 Tracing process ID 11111 total read pwrite write fdatasync fsync lseek filename 2903317005 160848 0 160848 0 0 2902995309 /data/3306/sql_log/relay-bin.000100 8421376 0 8421376 0 0 0 0 /data/3306/data/ibdata1 492544 0 492544 0 0 0 0 /data/3306/data/ib_logfile0 159383 0 0 159383 0 0 0 /data/3306/sql_log/mysql-bin.000054 0 0 0 0 0 0 0 /data/3306/data/mysql/slave_relay_log_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_role.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_relation.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_login_log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_base_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/personal_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/operation_journal.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/message_received.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/message_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_userinfo.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user_cache.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user_amount.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_credit.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_borrow_auto.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_account.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/gift_money_trade.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/gift_money.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_front/log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/app_request_log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/app_equipment_login.ibd /opt/percona-toolkit-3.0.3/bin/pt-ioprofile --profile-pid=11111 --cell=sizes --cell=sizes Fri Jun 16 12:42:21 CST 2017 Tracing process ID 11111 total read pwrite write fdatasync fsync lseek filename 3533810812 153878 0 153878 0 0 3533503056 /data/3306/sql_log/relay-bin.000100 13811712 0 13811712 0 0 0 0 /data/3306/data/ibdata1 536064 0 536064 0 0 0 0 /data/3306/data/ib_logfile0 152138 0 0 152138 0 0 0 /data/3306/sql_log/mysql-bin.000054 0 0 0 0 0 0 0 /data/3306/data/mysql/slave_relay_log_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_role.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_relation.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_login_log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/user_base_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/personal_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/operation_journal.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/message_received.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/message_info.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_userinfo.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user_cache.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_user_amount.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_notice.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_credit.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_borrow_auto.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_account_recharge.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_internal/dw_account.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/gift_money_trade.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/gift_money.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_front/recharge.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp_front/log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/app_request_log.ibd 0 0 0 0 0 0 0 /data/3306/data/jsp/app_equipment_login.ibd |
1：http://www.cnblogs.com/ToDoToTry/p/4451281.html
2：http://www.cnblogs.com/xuanzhi201111/p/4040761.html
3：https://www.percona.com/doc/percona-toolkit/2.0/pt-ioprofile.html
4：http://www.cnblogs.com/cenalulu/archive/2013/04/12/3016714.html
5：http://www.cnblogs.com/legendbaby/p/5056967.html
6：http://www.cnblogs.com/cenalulu/archive/2013/04/12/3016714.html
7:http://www.cnblogs.com/ToDoToTry/p/4451281.html
8文 章 源 自 note.t4x.orgByrd's Blog-https://note.t4x.org/other/install-pt-ioprofile/ 文 章 源 自 note.t4x.orgByrd's Blog-https://note.t4x.org/other/install-pt-ioprofile/
申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!
