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 | 4678 | 24905887363632 | 5324046024 | 192958303296 | 981823920 | 924570070512 | 23980335469200 | 8 | 70656 | 8832.0000 | 2981 | 4608000 | 1545.7900 | |
innodb/innodb_data_file | 7186 | 15292616585136 | 2128112448 | 225338121360 | 314782527840 | 195696042960 | 14782138014336 | 1444 | 28770304 | 19924.0332 | 4159 | 144031744 | 34631.3402 | |
sql/binlog | 821 | 1823707801344 | 2221324776 | 42475833312 | 1164380448 | 5528680080 | 1817014740816 | 145 | 1176 | 8.1103 | 117 | 37681 | 322.0598 | |
innodb/innodb_temp_file | 222 | 679953554016 | 3062853816 | 67591920000 | 0 | 4240253952 | 675713300064 | 0 | 0 | 0.0000 | 146 | 4096000 | 28054.7945 | |
sql/ERRMSG | 60 | 58842495888 | 980708256 | 13525353072 | 26113276464 | 0 | 32729219424 | 36 | 3672054 | 102001.5000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 42252320352 | 1111903056 | 22438647264 | 292516752 | 0 | 41959803600 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 238 | 7396068768 | 31075704 | 1025559744 | 490533120 | 4075615104 | 2829920544 | 90 | 5270362 | 58559.5778 | 98 | 5244118 | 53511.4082 | |
csv/metadata | 8 | 1331884224 | 166485528 | 581799504 | 1060754640 | 0 | 271129584 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 800742624 | 160148472 | 783989184 | 785266944 | 0 | 15475680 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 755088048 | 50338992 | 682369248 | 0 | 0 | 755088048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 616528176 | 154131912 | 336347616 | 0 | 0 | 616528176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 260045280 | 86681760 | 247510032 | 247510032 | 0 | 12535248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 11 | 197188992 | 17926128 | 38439456 | 0 | 0 | 197188992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 33473088 | 11157696 | 20037600 | 0 | 11554224 | 21918864 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|