SELECT * FROM `x$waits_by_host_by_latency`
|
host | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 44 | 504193853856 | 11458951152 | 88774804800 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 335 | 154204793952 | 460312776 | 13569445296 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 25 | 31694799312 | 1267791888 | 9878099616 | |
192.168.30.20 | wait/io/file/sql/binlog | 148 | 29373572448 | 198469920 | 14696977152 | |
192.168.30.20 | wait/io/table/sql/handler | 350 | 13652339184 | 39006528 | 10729399824 | |
192.168.30.20 | wait/io/file/sql/io_cache | 80 | 6478231056 | 80977776 | 2452498224 | |
192.168.30.20 | wait/io/file/myisam/kfile | 8 | 2097751920 | 262218792 | 1799262432 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 656342016 | 164085504 | 540836736 | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 328203216 | 164101608 | 312686352 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 317903520 | 158951760 | 316098288 | |
192.168.30.20 | wait/lock/table/sql/handler | 121 | 135325344 | 1118304 | 12241680 | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 51550752 | 12887688 | 28551600 | |
192.168.30.20 | wait/io/file/csv/data | 2 | 39830208 | 19915104 | 32494176 | |
background | wait/io/file/innodb/innodb_log_file | 335 | 1830461797824 | 5464065024 | 130580100288 | |
background | wait/io/file/innodb/innodb_data_file | 1674 | 1271312982720 | 759446160 | 259712198592 | |
background | wait/io/file/innodb/innodb_temp_file | 101 | 380747966016 | 3769781664 | 39001294992 | |
background | wait/io/file/sql/binlog_index | 36 | 46803702528 | 1300102848 | 28161774960 | |
background | wait/io/file/sql/binlog | 37 | 39027461616 | 1054796160 | 21788605344 | |
background | wait/io/file/sql/ERRMSG | 5 | 2205873648 | 441174624 | 1350078576 | |
background | wait/io/file/sql/casetest | 15 | 768659760 | 51243984 | 706851552 | |
background | wait/io/file/mysys/cnf | 5 | 566291616 | 113258112 | 544069680 | |
background | wait/io/file/mysys/charset | 3 | 269229312 | 89743104 | 253657536 | |
background | wait/io/file/sql/pid | 3 | 47600256 | 15866664 | 37068240 | |
background | wait/io/file/sql/misc | 1 | 11724240 | 11724240 | 11724240 |
|