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 | 313 | 1668447835296 | 5330504256 | 56242332960 | 1682047488 | 78407438736 | 1588358349072 | 8 | 70656 | 8832.0000 | 181 | 161280 | 891.0497 | |
innodb/innodb_data_file | 1786 | 1009252834128 | 565090944 | 234183327312 | 219020386464 | 14166528288 | 776065919376 | 1259 | 25739264 | 20444.2129 | 334 | 20660224 | 61856.9581 | |
innodb/innodb_temp_file | 90 | 360776186496 | 4008624048 | 28882789584 | 0 | 2400479136 | 358375707360 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 81741766656 | 2151098928 | 57803137392 | 1964673744 | 0 | 79777092912 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 85 | 36372624288 | 427913112 | 17386301856 | 805906992 | 55882992 | 35510834304 | 18 | 668 | 37.1111 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 18906517344 | 756260472 | 2697389904 | 13688165040 | 0 | 5218352304 | 15 | 1525348 | 101689.8667 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1629617616 | 325923312 | 1606029216 | 1608020832 | 0 | 21596784 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 840692688 | 56046144 | 757797744 | 0 | 0 | 840692688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 226924368 | 75641280 | 216017472 | 216017472 | 0 | 10906896 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 50989488 | 16996320 | 33229680 | 0 | 15217488 | 35772000 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 5512320 | 5512320 | 5512320 | 0 | 0 | 5512320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|