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 | 589 | 3287507991504 | 5581507536 | 113223703824 | 1603555008 | 179634331008 | 3106270105488 | 8 | 70656 | 8832.0000 | 351 | 342016 | 974.4046 | |
innodb/innodb_data_file | 2312 | 1508693826816 | 652549128 | 241350748320 | 183501143760 | 38208924864 | 1286983758192 | 1319 | 26722304 | 20259.5178 | 735 | 33374208 | 45407.0857 | |
innodb/innodb_temp_file | 102 | 445611807168 | 4368743016 | 24717353232 | 0 | 3173924160 | 442437883008 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | |
sql/binlog | 191 | 102900143280 | 538744008 | 17272766544 | 1554569280 | 868917984 | 100476656016 | 42 | 764 | 18.1905 | 8 | 1366 | 170.7500 | |
sql/binlog_index | 38 | 59069941392 | 1554472128 | 41429181552 | 686170848 | 0 | 58383770544 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 80 | 47296563072 | 591206880 | 5970631392 | 26135304096 | 0 | 21161258976 | 48 | 4905306 | 102193.8750 | 0 | 0 | 0.0000 | |
csv/data | 6 | 1996664736 | 332777280 | 1936020768 | 33246576 | 0 | 1963418160 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 1767014304 | 589004592 | 1739740992 | 0 | 0 | 1767014304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1111683408 | 74112192 | 1053203184 | 0 | 0 | 1111683408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1058752992 | 211750440 | 1040713344 | 1041906096 | 0 | 16846896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 792772464 | 99096360 | 385660704 | 614706576 | 0 | 178065888 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 319573056 | 106524264 | 305062560 | 305062560 | 0 | 14510496 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 20325888 | 6775296 | 16431360 | 0 | 2844864 | 17481024 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|