SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 621 | 3613161222000 | 5818294944 | 147445509552 | 1121912352 | 108478386192 | 3503560923456 | 8 | 70656 | 8832.0000 | 350 | 275456 | 787.0171 | |
innodb/innodb_data_file | 2584 | 3213137944896 | 1243474320 | 222775784880 | 193797685488 | 33495474672 | 2985844784736 | 1338 | 27033600 | 20204.4843 | 793 | 34258944 | 43201.6948 | |
innodb/innodb_temp_file | 814 | 1365565102176 | 1677598296 | 41628665760 | 0 | 29295885168 | 1336269217008 | 0 | 0 | 0.0000 | 700 | 15663104 | 22375.8629 | |
sql/binlog | 349 | 72728641392 | 208391304 | 19664604960 | 3296828304 | 1061405664 | 68370407424 | 83 | 928 | 11.1807 | 5 | 638 | 127.6000 | |
sql/ERRMSG | 65 | 48582303792 | 747419904 | 5312789328 | 23314967280 | 0 | 25267336512 | 39 | 3999811 | 102559.2564 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 47432794992 | 1248231336 | 26943374832 | 360801408 | 0 | 47071993584 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 56 | 17227423488 | 307632336 | 15534892032 | 122789568 | 871014672 | 16233619248 | 20 | 1513508 | 75675.4000 | 26 | 1513508 | 58211.8462 | |
sql/casetest | 15 | 917246880 | 61149792 | 842346384 | 0 | 0 | 917246880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 678474720 | 135694944 | 648228240 | 649547184 | 0 | 28927536 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 55 | 310358400 | 5642736 | 252497520 | 283252464 | 0 | 27105936 | 50 | 1950 | 39.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 269424144 | 89808048 | 252202368 | 252202368 | 0 | 17221776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 249455184 | 62363664 | 229694256 | 231427680 | 0 | 18027504 | 2 | 407 | 203.5000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48376944 | 16125648 | 37272576 | 0 | 8326560 | 40050384 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 27883680 | 9294384 | 11548416 | 0 | 0 | 27883680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|