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 | 967 | 5481629176320 | 5668695912 | 102523776432 | 1518118272 | 111178450416 | 5368932607632 | 8 | 70656 | 8832.0000 | 576 | 627712 | 1089.7778 | |
innodb/innodb_data_file | 2888 | 4540529328192 | 1572205272 | 240852355392 | 242229510336 | 56462368512 | 4241837449344 | 1341 | 27082752 | 20195.9374 | 1036 | 41992192 | 40533.0039 | |
innodb/innodb_temp_file | 235 | 1512603163104 | 6436609080 | 315185863344 | 0 | 321274401888 | 1191328761216 | 0 | 0 | 0.0000 | 136 | 5439488 | 39996.2353 | |
sql/binlog | 543 | 339666003600 | 625535856 | 37872024432 | 3005567136 | 3429477216 | 333230959248 | 124 | 1092 | 8.8065 | 20 | 5463 | 273.1500 | |
sql/binlog_index | 38 | 42411867696 | 1116101712 | 22757886624 | 1687446288 | 0 | 40724421408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 37965837360 | 632763912 | 4481761152 | 20015094528 | 0 | 17950742832 | 36 | 3684530 | 102348.0556 | 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 | 10 | 198367488 | 19836696 | 32951424 | 0 | 0 | 198367488 | 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 |
|