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 | 858 | 5360240611968 | 6247366488 | 259781341776 | 1030167072 | 311609406240 | 5047601038656 | 8 | 70656 | 8832.0000 | 494 | 416768 | 843.6599 | |
innodb/innodb_data_file | 3078 | 4356402756816 | 1415335416 | 254264789856 | 259587544656 | 34737118944 | 4062078093216 | 1435 | 28622848 | 19946.2355 | 1077 | 42811392 | 39750.5961 | |
innodb/innodb_temp_file | 365 | 2151689625360 | 5895040008 | 599957440896 | 0 | 387336880128 | 1764352745232 | 0 | 0 | 0.0000 | 270 | 7372800 | 27306.6667 | |
sql/binlog | 185 | 225066371904 | 1216574832 | 27556310496 | 3428016240 | 4186409568 | 217451946096 | 38 | 748 | 19.6842 | 13 | 2784 | 214.1538 | |
sql/binlog_index | 38 | 69106323264 | 1818587232 | 36383164752 | 341527296 | 0 | 68764795968 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 25218082032 | 504361440 | 4617447120 | 15147256080 | 0 | 10070825952 | 30 | 3074804 | 102493.4667 | 0 | 0 | 0.0000 | |
sql/io_cache | 78 | 3681987936 | 47204784 | 2398805376 | 306222576 | 699961152 | 2675804208 | 36 | 1925908 | 53497.4444 | 32 | 1925908 | 60184.6250 | |
sql/casetest | 15 | 725116656 | 48341040 | 664429920 | 0 | 0 | 725116656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 517715088 | 103542912 | 501350256 | 502560432 | 0 | 15154656 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 509581248 | 127395312 | 487877280 | 489655584 | 0 | 19925664 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 262978848 | 87659616 | 251044992 | 251044992 | 0 | 11933856 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 258134976 | 86044992 | 232526976 | 0 | 0 | 258134976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 52643712 | 17547816 | 40858224 | 0 | 8718336 | 43925376 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 1 | 10060512 | 10060512 | 10060512 | 0 | 0 | 10060512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|