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_data_file | 1508 | 754057221984 | 500037912 | 226065427104 | 228318114288 | 20519125968 | 505219981728 | 1146 | 23887872 | 20844.5654 | 193 | 16203776 | 83957.3886 | |
innodb/innodb_log_file | 97 | 546264183168 | 5631589392 | 59495663568 | 1574560416 | 8986906896 | 535702715856 | 8 | 70656 | 8832.0000 | 49 | 68608 | 1400.1633 | |
innodb/innodb_temp_file | 100 | 499287296112 | 4992872808 | 63348158016 | 0 | 2743334352 | 496543961760 | 0 | 0 | 0.0000 | 36 | 1507328 | 41870.2222 | |
sql/binlog_index | 38 | 51742517904 | 1361645208 | 33511287216 | 538724208 | 0 | 51203793696 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 79 | 51684522912 | 654234240 | 20397686496 | 529515360 | 49796736 | 51105210816 | 16 | 660 | 41.2500 | 4 | 394 | 98.5000 | |
sql/ERRMSG | 50 | 32261918304 | 645238176 | 1984101504 | 19544087904 | 0 | 12717830400 | 30 | 3061232 | 102041.0667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1244086800 | 82939032 | 1186486224 | 0 | 0 | 1244086800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 609487824 | 121897512 | 590212128 | 591517872 | 0 | 17969952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 286620048 | 95540016 | 271567824 | 271567824 | 0 | 15052224 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 118985856 | 39661776 | 80534256 | 0 | 80534256 | 38451600 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 26735280 | 13367640 | 14012064 | 0 | 0 | 26735280 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|