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 | 1500 | 694270210656 | 462846648 | 249265347408 | 197363635920 | 29952246192 | 466954328544 | 1151 | 23969792 | 20825.1885 | 184 | 15974400 | 86817.3913 | |
innodb/innodb_log_file | 85 | 436544137392 | 5135813232 | 46057969584 | 1388960496 | 7555483584 | 427599693312 | 8 | 70656 | 8832.0000 | 43 | 65536 | 1524.0930 | |
innodb/innodb_temp_file | 90 | 373741211184 | 4152679872 | 36301208592 | 0 | 2422776048 | 371318435136 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 53656061712 | 1412001624 | 33165855888 | 2004162336 | 0 | 51651899376 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 45 | 41273158080 | 917181144 | 20395475760 | 1162536672 | 94261200 | 40016360208 | 8 | 628 | 78.5000 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 45 | 18601753104 | 413372256 | 1612612848 | 15429044400 | 0 | 3172708704 | 27 | 2765986 | 102443.9259 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1015297536 | 203059296 | 994640592 | 996268944 | 0 | 19028592 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1001330352 | 66755304 | 929691840 | 0 | 0 | 1001330352 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 243014112 | 81004704 | 229866912 | 229866912 | 0 | 13147200 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 45462384 | 15154128 | 35883408 | 0 | 6876144 | 38586240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 11700480 | 11700480 | 11700480 | 0 | 0 | 11700480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|