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 | 115 | 616503694752 | 5360901480 | 59542005072 | 971383776 | 10926296832 | 604606014144 | 8 | 70656 | 8832.0000 | 62 | 75776 | 1222.1935 | |
innodb/innodb_data_file | 1550 | 614111508912 | 396200904 | 215743525008 | 126976496592 | 8756648208 | 478378364112 | 1160 | 24117248 | 20790.7310 | 211 | 16826368 | 79745.8199 | |
innodb/innodb_temp_file | 90 | 328696388592 | 3652182072 | 29512136544 | 0 | 827531232 | 327868857360 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 36 | 43920305088 | 1220008416 | 28515579312 | 285126336 | 0 | 43635178752 | 8 | 256 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 37 | 29298397392 | 791848464 | 16215857856 | 639854688 | 23388288 | 28635154416 | 6 | 620 | 103.3333 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 15 | 7127206416 | 475146936 | 2290507824 | 3787130160 | 0 | 3340076256 | 9 | 913582 | 101509.1111 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 2591867520 | 518373504 | 2572555920 | 2573908128 | 0 | 17959392 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 798333360 | 53222136 | 724239120 | 0 | 0 | 798333360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 257692512 | 85897416 | 244694736 | 244694736 | 0 | 12997776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13920720 | 4640064 | 11217888 | 0 | 1945680 | 11975040 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 4121040 | 4121040 | 4121040 | 0 | 0 | 4121040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|