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_data_file | 1502 | 478285552800 | 318432312 | 174330162336 | 133980718608 | 10987904928 | 333316929264 | 1223 | 23134208 | 18915.9509 | 194 | 16269312 | 83862.4330 | |
innodb/innodb_temp_file | 99 | 405903911952 | 4100039328 | 31946089296 | 0 | 1773393072 | 404130518880 | 0 | 0 | 0.0000 | 36 | 1441792 | 40049.7778 | |
innodb/innodb_log_file | 73 | 308172826368 | 4221545328 | 22696703040 | 812020704 | 1564061664 | 305796744000 | 8 | 70656 | 8832.0000 | 36 | 72704 | 2019.5556 | |
sql/binlog | 107 | 33652770624 | 314511648 | 16251955104 | 4478940048 | 29156688 | 29144673888 | 34 | 122915 | 3615.1471 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 30 | 21654787440 | 721826160 | 4180529760 | 9493979088 | 0 | 12160808352 | 18 | 1834454 | 101914.1111 | 0 | 0 | 0.0000 | |
sql/io_cache | 23 | 7711309056 | 335274192 | 6757732080 | 63900672 | 747648528 | 6899759856 | 8 | 558802 | 69850.2500 | 10 | 558802 | 55880.2000 | |
sql/binlog_index | 23 | 1051106496 | 45700248 | 324180384 | 774902832 | 0 | 276203664 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 847395648 | 56492832 | 771293424 | 0 | 0 | 847395648 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 244363680 | 81454560 | 227170416 | 227170416 | 0 | 17193264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 242400576 | 48479904 | 224960736 | 226088016 | 0 | 16312560 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46027872 | 15342624 | 27984528 | 0 | 15493632 | 30534240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 8136480 | 8136480 | 8136480 | 0 | 0 | 8136480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|