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 | 1510 | 8642846596560 | 5723739384 | 112813425120 | 1264386288 | 352699566384 | 8288882643888 | 8 | 70656 | 8832.0000 | 912 | 914432 | 1002.6667 | |
innodb/innodb_data_file | 3744 | 5834683029120 | 1558408896 | 206610177840 | 244942396512 | 68998385808 | 5520742246800 | 1445 | 28786688 | 19921.5834 | 1610 | 60342272 | 37479.6720 | |
innodb/innodb_temp_file | 278 | 881285014368 | 3170089824 | 81744599376 | 0 | 162221191968 | 719063822400 | 0 | 0 | 0.0000 | 199 | 5160960 | 25934.4724 | |
sql/io_cache | 82 | 350584110624 | 4275415848 | 250812213696 | 550781088 | 1441837584 | 348591491952 | 38 | 2049628 | 53937.5789 | 34 | 2049628 | 60283.1765 | |
sql/binlog | 419 | 192462822816 | 459338352 | 17898458688 | 977122080 | 990753984 | 190494946752 | 96 | 980 | 10.2083 | 14 | 3881 | 277.2143 | |
sql/ERRMSG | 70 | 50577051360 | 722529192 | 3949904640 | 28325899008 | 0 | 22251152352 | 42 | 4304192 | 102480.7619 | 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 | |
sql/casetest | 15 | 829782624 | 55318824 | 743861184 | 0 | 0 | 829782624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 11 | 387012912 | 35182752 | 200891856 | 61220016 | 0 | 325792896 | 2 | 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 | 12 | 60256944 | 5021280 | 10084272 | 0 | 0 | 60256944 | 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 |
|