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 | 509 | 2647567811856 | 5201508312 | 38965115904 | 1049190912 | 66738971904 | 2579779649040 | 8 | 70656 | 8832.0000 | 299 | 258048 | 863.0368 | |
innodb/innodb_data_file | 2516 | 1805266946208 | 717514512 | 193056931056 | 181191630576 | 29963853216 | 1594111462416 | 1533 | 30375936 | 19814.7006 | 659 | 30654464 | 46516.6373 | |
innodb/innodb_temp_file | 590 | 744946290528 | 1262620656 | 63615470688 | 0 | 6410399424 | 738535891104 | 0 | 0 | 0.0000 | 509 | 10371072 | 20375.3870 | |
sql/io_cache | 502 | 134968029504 | 268860504 | 87974837280 | 1327162320 | 10169366064 | 123471501120 | 240 | 12293644 | 51223.5167 | 202 | 12293644 | 60859.6238 | |
sql/binlog | 241 | 124915990848 | 518323608 | 20802262272 | 6405689136 | 1148035152 | 117362266560 | 56 | 7339 | 131.0536 | 8 | 1727 | 215.8750 | |
sql/ERRMSG | 80 | 44735958960 | 559199256 | 2956286256 | 25292580192 | 0 | 19443378768 | 48 | 4913439 | 102363.3125 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 1687327488 | 73361904 | 426533184 | 1050951264 | 0 | 636376224 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1153361616 | 76890528 | 1088362176 | 0 | 0 | 1153361616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 255759504 | 85252992 | 243990912 | 243990912 | 0 | 11768592 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 167694384 | 33538824 | 152746176 | 153472704 | 0 | 14221680 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 57339216 | 19113072 | 30623472 | 0 | 0 | 57339216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 26642880 | 8880960 | 20526000 | 0 | 4258848 | 22384032 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|