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 | 1377 | 8296647224976 | 6025161120 | 390494404608 | 1930543296 | 304303431168 | 7990413250512 | 8 | 70656 | 8832.0000 | 856 | 1219072 | 1424.1495 | |
innodb/innodb_data_file | 3153 | 5831768908416 | 1849593504 | 224988546816 | 306277682832 | 86161258128 | 5439329967456 | 1284 | 26148864 | 20365.1589 | 1253 | 49889280 | 39815.8659 | |
innodb/innodb_temp_file | 108 | 493238802144 | 4567025760 | 41453083056 | 0 | 2661584640 | 490577217504 | 0 | 0 | 0.0000 | 43 | 1687552 | 39245.3953 | |
sql/binlog | 342 | 467102704464 | 1365797136 | 31319099328 | 874624080 | 2283697680 | 463944382704 | 69 | 1019 | 14.7681 | 31 | 10093 | 325.5806 | |
sql/binlog_index | 38 | 51802032480 | 1363211256 | 32058328368 | 378331008 | 0 | 51423701472 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 33441413280 | 743142312 | 3428419104 | 19405538064 | 0 | 14035875216 | 27 | 2769120 | 102560.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 126 | 3422667600 | 27164016 | 600916800 | 244357344 | 1393750512 | 1784559744 | 46 | 2684830 | 58365.8696 | 50 | 2667334 | 53346.6800 | |
mysys/cnf | 5 | 3292047264 | 658409400 | 3275252112 | 3276422160 | 0 | 15625104 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 2115607296 | 528901824 | 2084164896 | 0 | 0 | 2115607296 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 879414624 | 58627536 | 812650080 | 0 | 0 | 879414624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 280023744 | 93341160 | 261075936 | 261075936 | 0 | 18947808 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46465584 | 15488352 | 36759888 | 0 | 7066752 | 39398832 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|