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 | 1737 | 10018634595552 | 5767780392 | 112813425120 | 1264386288 | 366879591408 | 9650490617856 | 8 | 70656 | 8832.0000 | 1039 | 997376 | 959.9384 | |
innodb/innodb_data_file | 4159 | 6974717781504 | 1677017760 | 206610177840 | 260411604288 | 77103003120 | 6637203174096 | 1544 | 30408704 | 19694.7565 | 1823 | 66469888 | 36461.8146 | |
innodb/innodb_temp_file | 305 | 1081300755216 | 3545248344 | 81744599376 | 0 | 163113253248 | 918187501968 | 0 | 0 | 0.0000 | 217 | 6045696 | 27860.3502 | |
sql/io_cache | 82 | 350584110624 | 4275415848 | 250812213696 | 550781088 | 1441837584 | 348591491952 | 38 | 2049628 | 53937.5789 | 34 | 2049628 | 60283.1765 | |
sql/binlog | 611 | 193537171344 | 316754592 | 17898458688 | 1145924208 | 990753984 | 191400493152 | 144 | 1172 | 8.1389 | 14 | 3881 | 277.2143 | |
sql/ERRMSG | 80 | 56588686176 | 707358432 | 3949904640 | 30217661760 | 0 | 26371024416 | 48 | 4913511 | 102364.8125 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 46279522608 | 1217882160 | 28618768992 | 1483775568 | 0 | 44795747040 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3259621728 | 407452584 | 1375563024 | 540197328 | 0 | 2719424400 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 3145148160 | 393143520 | 2396345952 | 3114788688 | 0 | 30359472 | 4 | 904 | 226.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 2312353824 | 462470712 | 2290204752 | 2291542176 | 0 | 20811648 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 56 | 904388496 | 16149672 | 262886976 | 383736672 | 0 | 520651824 | 21 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 829782624 | 55318824 | 743861184 | 0 | 0 | 829782624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 262245984 | 87415152 | 239860368 | 239860368 | 0 | 22385616 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 14 | 95921760 | 6851328 | 24412608 | 0 | 0 | 95921760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17251872 | 5750448 | 12990384 | 0 | 2934624 | 14317248 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 14479344 | 7239672 | 10614384 | 0 | 0 | 14479344 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|