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 | 1777 | 8450988104592 | 4755761208 | 56530325280 | 1253312544 | 303679333056 | 8146055458992 | 8 | 70656 | 8832.0000 | 1120 | 1596416 | 1425.3714 | |
innodb/innodb_data_file | 3975 | 4059516910944 | 1021262088 | 158702608416 | 294660026496 | 85743831888 | 3679113052560 | 1567 | 30883840 | 19708.8960 | 1867 | 70008832 | 37498.0354 | |
innodb/innodb_temp_file | 406 | 937875547488 | 2310038280 | 37630466544 | 0 | 11489545584 | 926386001904 | 0 | 0 | 0.0000 | 314 | 7897088 | 25149.9618 | |
sql/binlog | 333 | 353667157008 | 1062063288 | 23527084416 | 4226016960 | 1296450144 | 348144689904 | 70 | 7107 | 101.5286 | 26 | 13131 | 505.0385 | |
sql/io_cache | 172 | 38789437632 | 225519888 | 23786388912 | 452454816 | 12911569440 | 25425413376 | 86 | 3917800 | 45555.8140 | 66 | 3917800 | 59360.6061 | |
sql/ERRMSG | 50 | 33107439024 | 662148696 | 2739582912 | 18629929824 | 0 | 14477509200 | 30 | 3062463 | 102082.1000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 1395638112 | 60679872 | 371390448 | 529106688 | 0 | 866531424 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 762213408 | 50814192 | 649998624 | 0 | 0 | 762213408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 555271728 | 111054240 | 537440112 | 538833504 | 0 | 16438224 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 544121952 | 181373808 | 512163696 | 512163696 | 0 | 31958256 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48935040 | 16311504 | 38849712 | 0 | 7516608 | 41418432 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 17672688 | 5890896 | 9576864 | 0 | 0 | 17672688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|