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 | 2893 | 13182416771040 | 4556659536 | 114949024608 | 1432685232 | 499558740912 | 12681425344896 | 8 | 70656 | 8832.0000 | 1910 | 3222016 | 1686.9194 | |
innodb/innodb_data_file | 4832 | 6499448920272 | 1345084488 | 679879651968 | 272075221440 | 83305087536 | 6144068611296 | 1579 | 30982144 | 19621.3705 | 2352 | 85016576 | 36146.5034 | |
innodb/innodb_temp_file | 384 | 910263498672 | 2370477648 | 37375926720 | 0 | 22689569760 | 887573928912 | 0 | 0 | 0.0000 | 293 | 7487488 | 25554.5666 | |
sql/binlog | 345 | 762961896048 | 2211483648 | 27204531552 | 2226888048 | 4024616640 | 756710391360 | 56 | 820 | 14.6429 | 57 | 15867 | 278.3684 | |
sql/io_cache | 316 | 680722822032 | 2154186144 | 464072007168 | 919590672 | 126931090176 | 552872141184 | 152 | 7462378 | 49094.5921 | 124 | 7462378 | 60180.4677 | |
sql/ERRMSG | 60 | 48772734384 | 812878704 | 7904142576 | 23147795616 | 0 | 25624938768 | 36 | 3686666 | 102407.3889 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 45986038560 | 1210158840 | 29645548944 | 579655824 | 0 | 45406382736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 8303239824 | 1037904912 | 7048165344 | 996322272 | 0 | 7306917552 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1803762048 | 360752304 | 1767272496 | 1768633152 | 0 | 35128896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 857192688 | 57145968 | 777431424 | 0 | 0 | 857192688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 9 | 832103712 | 92455968 | 555111216 | 557066928 | 0 | 275036784 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 311792448 | 103930728 | 279432912 | 279432912 | 0 | 32359536 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 7 | 216477360 | 30925224 | 152258304 | 0 | 0 | 216477360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 44035200 | 6290592 | 10045728 | 0 | 0 | 44035200 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 40286928 | 10071600 | 16657872 | 0 | 0 | 40286928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17499504 | 5833080 | 13821456 | 0 | 2626800 | 14872704 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|