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 | 1567 | 8686181718192 | 5543191896 | 429268256208 | 1762230096 | 231543889104 | 8452875598992 | 8 | 70656 | 8832.0000 | 976 | 1259008 | 1289.9672 | |
innodb/innodb_data_file | 3403 | 6249173291328 | 1836371592 | 454573190016 | 774286697712 | 111276569184 | 5363610024432 | 1396 | 27983872 | 20045.7536 | 1350 | 52805632 | 39115.2830 | |
sql/binlog | 417 | 567044870304 | 1359819648 | 42609191328 | 2864112240 | 2997239520 | 561183518544 | 83 | 928 | 11.1807 | 39 | 12374 | 317.2821 | |
innodb/innodb_temp_file | 116 | 562845810912 | 4852118832 | 34405054992 | 0 | 3296170944 | 559549639968 | 0 | 0 | 0.0000 | 48 | 1966080 | 40960.0000 | |
sql/binlog_index | 38 | 46739872080 | 1229996592 | 28217923008 | 726771408 | 0 | 46013100672 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 45689910288 | 1015331328 | 6313648176 | 24900718656 | 0 | 20789191632 | 27 | 2771439 | 102645.8889 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 2378109888 | 594527472 | 2279011152 | 2287963920 | 0 | 90145968 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1348322976 | 269664384 | 1329540960 | 1331123904 | 0 | 17199072 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 846022848 | 56401488 | 780393504 | 0 | 0 | 846022848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 260205264 | 86735088 | 245562240 | 245562240 | 0 | 14643024 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 112984080 | 18830592 | 27231600 | 0 | 0 | 112984080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 41869872 | 13956624 | 32558592 | 0 | 6942144 | 34927728 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 33815760 | 16907880 | 32606112 | 0 | 0 | 33815760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|