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 | 52 | 537826123296 | 10342809840 | 33786832992 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 209 | 216098155152 | 1033962336 | 30807155808 | |
192.168.30.20 | wait/io/file/sql/binlog | 368 | 115046090016 | 312625104 | 26963583504 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 44860042656 | 815636976 | 6249837792 | |
192.168.30.20 | wait/io/table/sql/handler | 294 | 25346995344 | 86214216 | 8348616144 | |
192.168.30.20 | wait/io/file/sql/io_cache | 188 | 8784388272 | 46725360 | 3829873344 | |
192.168.30.20 | wait/io/file/myisam/dfile | 166 | 8655790176 | 52143168 | 8205714000 | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 4399291248 | 274955472 | 2284332336 | |
192.168.30.20 | wait/lock/table/sql/handler | 508 | 1329191424 | 2616504 | 566786880 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1294406784 | 161800848 | 534696096 | |
192.168.30.20 | wait/io/file/csv/data | 10 | 790079136 | 79007808 | 477754464 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 15159408 | 15159408 | 15159408 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4538688 | 2269344 | 3020688 | |
background | wait/io/file/innodb/innodb_log_file | 582 | 3339826962384 | 5738534208 | 83887098768 | |
background | wait/io/file/innodb/innodb_data_file | 2219 | 3062913283584 | 1380312384 | 244353626352 | |
background | wait/io/file/innodb/innodb_temp_file | 238 | 351400098192 | 1476470952 | 20598498096 | |
background | wait/io/file/sql/binlog_index | 36 | 51364891776 | 1426802520 | 27985089264 | |
background | wait/io/file/sql/binlog | 37 | 50011744464 | 1351668648 | 31498031136 | |
background | wait/io/file/sql/ERRMSG | 5 | 2156788128 | 431357520 | 1282528368 | |
background | wait/io/file/sql/casetest | 15 | 780922560 | 52061328 | 714407760 | |
background | wait/io/file/mysys/cnf | 5 | 504982896 | 100996368 | 486435312 | |
background | wait/io/file/mysys/charset | 3 | 286418352 | 95472696 | 272584224 | |
background | wait/io/file/sql/pid | 3 | 45614448 | 15204816 | 35258256 | |
background | wait/io/file/sql/misc | 1 | 3683856 | 3683856 | 3683856 |
|