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 | 732 | 3794564641824 | 5183831400 | 38965115904 | 1049190912 | 109519053072 | 3683996397840 | 8 | 70656 | 8832.0000 | 434 | 370688 | 854.1198 | |
innodb/innodb_data_file | 2779 | 2434587119712 | 876065784 | 193056931056 | 193923532176 | 37334407440 | 2203329180096 | 1569 | 30965760 | 19735.9847 | 828 | 35897344 | 43354.2802 | |
innodb/innodb_temp_file | 1079 | 1067286817344 | 989144376 | 63615470688 | 0 | 16245585312 | 1051041232032 | 0 | 0 | 0.0000 | 977 | 19415040 | 19872.0983 | |
sql/binlog | 475 | 191205327456 | 402537432 | 43494271392 | 58724680080 | 1536804192 | 130943843184 | 114 | 7571 | 66.4123 | 9 | 2211 | 245.6667 | |
sql/io_cache | 856 | 150035531712 | 175275144 | 87974837280 | 2216734080 | 13789644528 | 134029153104 | 412 | 20622836 | 50055.4272 | 344 | 20622836 | 59950.1047 | |
sql/ERRMSG | 85 | 49779173136 | 585637272 | 3006702336 | 27316613808 | 0 | 22462559328 | 51 | 5218658 | 102326.6275 | 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 |
|