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 | 1440 | 8327673431088 | 5783106384 | 141693816000 | 1793928576 | 254166525888 | 8071712976624 | 8 | 70656 | 8832.0000 | 874 | 1014784 | 1161.0801 | |
innodb/innodb_data_file | 3592 | 6757791074496 | 1881344784 | 641369316720 | 301425880272 | 103959632832 | 6352405561392 | 1410 | 28213248 | 20009.3957 | 1534 | 58310656 | 38012.1617 | |
innodb/innodb_temp_file | 150 | 795792741744 | 5305284864 | 45433418976 | 0 | 4661565216 | 791131176528 | 0 | 0 | 0.0000 | 72 | 3014656 | 41870.2222 | |
sql/binlog | 457 | 419022008592 | 916897080 | 29252385888 | 2524432416 | 1550730192 | 414946845984 | 99 | 992 | 10.0202 | 27 | 9279 | 343.6667 | |
sql/binlog_index | 38 | 43951605984 | 1156620960 | 22087234224 | 361644096 | 0 | 43589961888 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 37124470416 | 618741024 | 4164538224 | 21728029488 | 0 | 15396440928 | 36 | 3686400 | 102400.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 8488500768 | 1061062464 | 7537553760 | 697872912 | 0 | 7790627856 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 982673472 | 245668368 | 916799136 | 0 | 0 | 982673472 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 934280688 | 62285256 | 871910688 | 0 | 0 | 934280688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 797861328 | 159572160 | 778595136 | 780263616 | 0 | 17597712 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 32 | 699632208 | 21863424 | 57469632 | 173544096 | 308008272 | 218079840 | 8 | 767380 | 95922.5000 | 14 | 767380 | 54812.8571 | |
myisam/dfile | 308 | 421707264 | 1369104 | 269686560 | 339968112 | 0 | 81739152 | 200 | 11892 | 59.4600 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 346757136 | 86689152 | 318627936 | 325115472 | 0 | 21641664 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 274415328 | 91471776 | 261685776 | 261685776 | 0 | 12729552 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 144267552 | 16029552 | 27318192 | 0 | 0 | 144267552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 44758032 | 14919168 | 33262944 | 0 | 8640192 | 36117840 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|