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 | 1361 | 7303102925712 | 5365982952 | 429268256208 | 1762230096 | 214562827776 | 7086777867840 | 8 | 70656 | 8832.0000 | 859 | 1172480 | 1364.9360 | |
innodb/innodb_data_file | 3046 | 5020859115360 | 1648344984 | 454573190016 | 766640119872 | 97056867072 | 4157162128416 | 1388 | 27852800 | 20066.8588 | 1109 | 45793280 | 41292.4076 | |
innodb/innodb_temp_file | 116 | 562845810912 | 4852118832 | 34405054992 | 0 | 3296170944 | 559549639968 | 0 | 0 | 0.0000 | 48 | 1966080 | 40960.0000 | |
sql/binlog | 265 | 522750791904 | 1972644432 | 42609191328 | 2760569328 | 2257141392 | 517733081184 | 46 | 780 | 16.9565 | 37 | 11860 | 320.5405 | |
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 | 4 | 64423920 | 16105848 | 27231600 | 0 | 0 | 64423920 | 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 |
|