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 | 665 | 3389282441424 | 5096665200 | 30745367136 | 1406014896 | 68807078208 | 3319069348320 | 8 | 70656 | 8832.0000 | 388 | 324608 | 836.6186 | |
innodb/innodb_data_file | 2545 | 2441971272048 | 959516976 | 266339978784 | 215635986192 | 27454095504 | 2198881190352 | 1322 | 26771456 | 20250.7231 | 913 | 38748160 | 42440.4819 | |
innodb/innodb_temp_file | 90 | 435836061408 | 4842622752 | 42976739520 | 0 | 3402513312 | 432433548096 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog | 163 | 77638202400 | 476307744 | 22055526240 | 466508592 | 764586240 | 76407107568 | 36 | 740 | 20.5556 | 6 | 928 | 154.6667 | |
sql/binlog_index | 38 | 56662229184 | 1491111072 | 37200763776 | 571225776 | 0 | 56091003408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 27420918624 | 609353712 | 2966752800 | 18248228592 | 0 | 9172690032 | 27 | 2758421 | 102163.7407 | 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 | 4 | 189427392 | 47356848 | 151517520 | 0 | 0 | 189427392 | 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 |
|