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 | 2258 | 11737015899840 | 5197969656 | 33803855712 | 1406014896 | 310813343808 | 11424796541136 | 8 | 70656 | 8832.0000 | 1339 | 1018880 | 760.9261 | |
innodb/innodb_data_file | 4594 | 5258119923408 | 1144562232 | 266339978784 | 243084936864 | 56819742672 | 4958215243872 | 1392 | 27918336 | 20056.2759 | 2591 | 91734016 | 35404.8692 | |
innodb/innodb_temp_file | 99 | 504140218560 | 5092325304 | 42976739520 | 0 | 3616685424 | 500523533136 | 0 | 0 | 0.0000 | 36 | 1441792 | 40049.7778 | |
sql/binlog | 643 | 160483971648 | 249586128 | 25278922416 | 824857968 | 1004706912 | 158654406768 | 155 | 1510 | 9.7419 | 11 | 2390 | 217.2727 | |
sql/binlog_index | 38 | 56662229184 | 1491111072 | 37200763776 | 571225776 | 0 | 56091003408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 43723429200 | 672668040 | 2987675328 | 25128296688 | 0 | 18595132512 | 39 | 3991856 | 102355.2821 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 3028847712 | 189302784 | 1665328896 | 2969182656 | 0 | 59665056 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
myisam/dfile | 225 | 2372834112 | 10545744 | 1948257168 | 2218053552 | 0 | 154780560 | 150 | 9296 | 61.9733 | 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 | 6 | 205422096 | 34236840 | 151517520 | 0 | 0 | 205422096 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 70702896 | 11783640 | 19804752 | 0 | 0 | 70702896 | 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 |
|