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 | 897 | 1941122749104 | 2164016184 | 40020084192 | |
192.168.30.20 | wait/io/file/sql/binlog | 3495 | 1565082951696 | 447806040 | 40185303840 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 20 | 195071599008 | 9753579792 | 30247074528 | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 9 | 129460969440 | 14384552160 | 27157181568 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 45960312288 | 766004976 | 3614040672 | |
192.168.30.20 | wait/io/table/sql/handler | 337 | 14655882912 | 43489248 | 4095881856 | |
192.168.30.20 | wait/io/file/sql/io_cache | 174 | 6159361296 | 35398440 | 2931083760 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1627961280 | 203495160 | 573347808 | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 682840752 | 170710056 | 636099024 | |
192.168.30.20 | wait/io/file/sql/misc | 26 | 617176032 | 23737296 | 241826640 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 479943552 | 119985888 | 310747008 | |
192.168.30.20 | wait/lock/table/sql/handler | 207 | 257527248 | 1243968 | 14019456 | |
192.168.30.20 | wait/io/file/csv/data | 10 | 179874816 | 17987376 | 40557264 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5049264 | 2524632 | 3060816 | |
background | wait/io/file/innodb/innodb_log_file | 4111 | 19478600536032 | 4738165872 | 83108643552 | |
background | wait/io/file/innodb/innodb_data_file | 4980 | 9214750220016 | 1850351448 | 1013083075488 | |
background | wait/io/file/innodb/innodb_temp_file | 197 | 393252280608 | 1996204320 | 29635887600 | |
background | wait/lock/metadata/sql/mdl | 2 | 305256355536 | 152628177768 | 256741803120 | |
background | wait/io/file/sql/binlog_index | 36 | 48256676160 | 1340463168 | 26313887952 | |
background | wait/io/file/sql/binlog | 37 | 33943575600 | 917393928 | 16119967248 | |
background | wait/io/file/sql/ERRMSG | 5 | 2225581248 | 445116144 | 1424457936 | |
background | wait/io/file/sql/casetest | 15 | 1100043648 | 73336032 | 1034840400 | |
background | wait/io/file/mysys/cnf | 5 | 463030128 | 92605920 | 443220624 | |
background | wait/io/file/mysys/charset | 3 | 332276736 | 110758824 | 319271040 | |
background | wait/io/file/sql/pid | 3 | 55850256 | 18616752 | 35049696 |
|