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 | 4296 | 22988266404576 | 5351085960 | 192958303296 | 981823920 | 863892872304 | 22123391708352 | 8 | 70656 | 8832.0000 | 2736 | 4256256 | 1555.6491 | |
innodb/innodb_data_file | 6762 | 14323336479408 | 2118209808 | 225338121360 | 313980671664 | 185297804208 | 13824058003536 | 1441 | 28721152 | 19931.4032 | 3853 | 134070272 | 34796.3332 | |
sql/binlog | 761 | 1695937277232 | 2228563920 | 42475833312 | 1132474464 | 3966391968 | 1690838410800 | 134 | 1132 | 8.4478 | 109 | 34813 | 319.3853 | |
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 | 208 | 6962195328 | 33472032 | 1025559744 | 447543888 | 3874329888 | 2640321552 | 82 | 4712538 | 57469.9756 | 86 | 4695042 | 54593.5116 | |
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 |
|