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 | 882 | 4920372834960 | 5578653960 | 102523776432 | 1518118272 | 110309431584 | 4808545285104 | 8 | 70656 | 8832.0000 | 527 | 592896 | 1125.0398 | |
innodb/innodb_data_file | 2665 | 3925126218288 | 1472842800 | 240852355392 | 234094282224 | 52427096832 | 3638604839232 | 1315 | 26656768 | 20271.3065 | 899 | 37928960 | 42190.1669 | |
innodb/innodb_temp_file | 220 | 1398774631584 | 6358066440 | 315185863344 | 0 | 320741430768 | 1078033200816 | 0 | 0 | 0.0000 | 126 | 4947968 | 39269.5873 | |
sql/binlog | 485 | 325882568352 | 671922768 | 37872024432 | 2966608656 | 3390923184 | 319525036512 | 110 | 1036 | 9.4182 | 19 | 5213 | 274.3684 | |
sql/binlog_index | 38 | 42411867696 | 1116101712 | 22757886624 | 1687446288 | 0 | 40724421408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 33697571424 | 612683016 | 4481761152 | 17714793360 | 0 | 15982778064 | 33 | 3379253 | 102401.6061 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3267058080 | 408382128 | 1703162208 | 2383439520 | 0 | 883618560 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 1561358832 | 390339576 | 1443176064 | 0 | 0 | 1561358832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 796515984 | 53100960 | 707077536 | 0 | 0 | 796515984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 580085088 | 116016912 | 555559488 | 557613936 | 0 | 22471152 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 302893536 | 100964424 | 291339840 | 291339840 | 0 | 11553696 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 166545984 | 18505080 | 32951424 | 0 | 0 | 166545984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46673616 | 15557784 | 35909808 | 0 | 8233104 | 38440512 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|