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 | 521 | 2605286188032 | 5000549136 | 30745367136 | 1406014896 | 50508013248 | 2553372159888 | 8 | 70656 | 8832.0000 | 301 | 252416 | 838.5914 | |
innodb/innodb_data_file | 2234 | 1912051205856 | 855886680 | 266339978784 | 215220121776 | 22361701296 | 1674469382784 | 1321 | 26755072 | 20253.6503 | 641 | 30228480 | 47158.3151 | |
innodb/innodb_temp_file | 90 | 435836061408 | 4842622752 | 42976739520 | 0 | 3402513312 | 432433548096 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 56662229184 | 1491111072 | 37200763776 | 571225776 | 0 | 56091003408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 143 | 53127292944 | 371519280 | 22055526240 | 455509824 | 524924928 | 52146858192 | 32 | 724 | 22.6250 | 4 | 411 | 102.7500 | |
sql/ERRMSG | 40 | 26340833376 | 658520808 | 2966752800 | 17442683280 | 0 | 8898150096 | 24 | 2451954 | 102164.7500 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 876598272 | 109574784 | 360032640 | 616252032 | 0 | 260346240 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 851156592 | 56743632 | 786105936 | 0 | 0 | 851156592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 655022016 | 131004192 | 635520336 | 636726288 | 0 | 18295728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 264019008 | 88006248 | 248145216 | 248145216 | 0 | 15873792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 160327728 | 80163864 | 151517520 | 0 | 0 | 160327728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 40122192 | 13373976 | 25926912 | 0 | 12000384 | 28121808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 4 | 33392304 | 8347944 | 10098000 | 0 | 0 | 33392304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|