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 | 1525 | 728731898400 | 477856896 | 268498708368 | 187380342864 | 22455921840 | 518895633696 | 1165 | 24199168 | 20771.8180 | 188 | 16039936 | 85318.8085 | |
innodb/innodb_temp_file | 114 | 534012677616 | 4684321488 | 28244143488 | 0 | 3262857312 | 530749820304 | 0 | 0 | 0.0000 | 45 | 1982464 | 44054.7556 | |
innodb/innodb_log_file | 82 | 385398512400 | 4699981704 | 47939551968 | 1351187904 | 3448322064 | 380599002432 | 8 | 70656 | 8832.0000 | 41 | 64512 | 1573.4634 | |
sql/binlog_index | 38 | 47805517056 | 1258039728 | 30003062496 | 545611440 | 0 | 47259905616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 117 | 34895827824 | 298254792 | 17093657856 | 1218203712 | 31886976 | 33645737136 | 26 | 700 | 26.9231 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 40 | 16511563728 | 412789080 | 2923651104 | 10071073584 | 0 | 6440490144 | 24 | 2440097 | 101670.7083 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1268551152 | 84570024 | 1207346976 | 0 | 0 | 1268551152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 712255632 | 142450968 | 694030656 | 695257200 | 0 | 16998432 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 307171392 | 102390288 | 293670960 | 293670960 | 0 | 13500432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17805744 | 5935248 | 14233296 | 0 | 2736624 | 15069120 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13519968 | 13519968 | 13519968 | 0 | 0 | 13519968 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|