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 | 714 | 3641925940224 | 5100736608 | 30745367136 | 1406014896 | 77008079808 | 3563511845520 | 8 | 70656 | 8832.0000 | 418 | 347648 | 831.6938 | |
innodb/innodb_data_file | 2585 | 2508454563120 | 970388496 | 266339978784 | 215635986192 | 27915502032 | 2264903074896 | 1322 | 26771456 | 20250.7231 | 948 | 39862272 | 42048.8101 | |
innodb/innodb_temp_file | 90 | 435836061408 | 4842622752 | 42976739520 | 0 | 3402513312 | 432433548096 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog | 187 | 77749991088 | 415775184 | 22055526240 | 482995392 | 764586240 | 76502409456 | 42 | 764 | 18.1905 | 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 |
|