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_data_file | 744 | 885797252736 | 1190587464 | 34419786192 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 50 | 418722688560 | 8374453560 | 28343480352 | |
192.168.30.20 | wait/io/table/sql/handler | 67762 | 280389616848 | 4137672 | 34158586704 | |
192.168.30.20 | wait/io/file/sql/binlog | 271 | 256327776144 | 945858936 | 28404805440 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 33333195456 | 666663888 | 3517949952 | |
192.168.30.20 | wait/io/file/sql/io_cache | 114 | 11860935504 | 104043192 | 6399805632 | |
192.168.30.20 | wait/io/file/myisam/dfile | 8311 | 5623445520 | 676368 | 1545031488 | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 4730553168 | 295659408 | 2683534656 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1897460928 | 237182616 | 1241215536 | |
192.168.30.20 | wait/lock/table/sql/handler | 545 | 645813168 | 1184832 | 11602272 | |
192.168.30.20 | wait/io/file/sql/misc | 2 | 229159920 | 114579960 | 218863920 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 83823696 | 20955792 | 45913824 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5331744 | 2665872 | 3679632 | |
background | wait/io/file/innodb/innodb_log_file | 1372 | 7194373611744 | 5243712408 | 76599297984 | |
background | wait/io/file/innodb/innodb_data_file | 2939 | 4180695929520 | 1422489024 | 224270116752 | |
background | wait/io/file/innodb/innodb_temp_file | 111 | 387429035136 | 3490351656 | 29091533856 | |
background | wait/lock/metadata/sql/mdl | 2 | 363492647760 | 181746323880 | 363482561904 | |
background | wait/io/file/sql/binlog_index | 36 | 40359005808 | 1121083392 | 20807105616 | |
background | wait/io/file/sql/binlog | 37 | 34364369424 | 928766520 | 16179321840 | |
background | wait/io/file/sql/ERRMSG | 5 | 1443604272 | 288720696 | 471228384 | |
background | wait/io/file/sql/casetest | 15 | 861041280 | 57402576 | 793168992 | |
background | wait/io/file/mysys/cnf | 5 | 473373120 | 94674624 | 457567968 | |
background | wait/io/file/mysys/charset | 3 | 316857552 | 105619008 | 297413952 | |
background | wait/io/file/sql/pid | 3 | 48607680 | 16202472 | 37294752 | |
background | wait/io/file/sql/misc | 1 | 14526864 | 14526864 | 14526864 |
|