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 | 1674 | 1880398542528 | 1123296504 | 611176054896 | 218898153936 | 27937214976 | 1633563173616 | 1184 | 24510464 | 20701.4054 | 283 | 18923520 | 66867.5618 | |
innodb/innodb_log_file | 217 | 1718696270016 | 7920259248 | 420408344928 | 1736513856 | 440280405840 | 1276679350320 | 8 | 70656 | 8832.0000 | 122 | 114688 | 940.0656 | |
innodb/innodb_temp_file | 131 | 654255031056 | 4994313192 | 40648640208 | 0 | 4569590256 | 649685440800 | 0 | 0 | 0.0000 | 58 | 2457600 | 42372.4138 | |
sql/binlog_index | 38 | 49799609904 | 1310515800 | 29503493184 | 1144891440 | 0 | 48654718464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 38020372896 | 1086296112 | 6031572096 | 21454848624 | 0 | 16565524272 | 21 | 2148708 | 102319.4286 | 0 | 0 | 0.0000 | |
sql/binlog | 249 | 37424001120 | 150297048 | 15860977440 | 3156587280 | 62936016 | 34204477824 | 59 | 832 | 14.1017 | 3 | 156 | 52.0000 | |
mysys/cnf | 5 | 1319936112 | 263987064 | 1304207520 | 1305415584 | 0 | 14520528 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1283246976 | 85549728 | 1204769280 | 0 | 0 | 1283246976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 366423024 | 122140920 | 341266464 | 341266464 | 0 | 25156560 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 49798848 | 16599528 | 38854992 | 0 | 8213040 | 41585808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 9412128 | 9412128 | 9412128 | 0 | 0 | 9412128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|