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 | 2359 | 12237483192000 | 5187572280 | 37430622768 | 1406014896 | 314993118000 | 11921084059104 | 8 | 70656 | 8832.0000 | 1403 | 1088512 | 775.8460 | |
innodb/innodb_data_file | 5052 | 5732860525920 | 1134770472 | 266339978784 | 346237374912 | 59661771840 | 5326961379168 | 1540 | 30343168 | 19703.3558 | 2834 | 99500032 | 35109.3973 | |
innodb/innodb_temp_file | 99 | 504140218560 | 5092325304 | 42976739520 | 0 | 3616685424 | 500523533136 | 0 | 0 | 0.0000 | 36 | 1441792 | 40049.7778 | |
sql/binlog | 645 | 173686171824 | 269280792 | 25278922416 | 824857968 | 1018842000 | 171842471856 | 155 | 1510 | 9.7419 | 12 | 2745 | 228.7500 | |
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 |
|