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 | 965 | 5375529404784 | 5570496624 | 82301119824 | 1789877232 | 180799666608 | 5192939860944 | 8 | 70656 | 8832.0000 | 584 | 638464 | 1093.2603 | |
innodb/innodb_data_file | 3195 | 4280291889456 | 1339684368 | 234943721232 | 295306233552 | 64953455424 | 3920032200480 | 1458 | 28999680 | 19890.0412 | 1260 | 49758208 | 39490.6413 | |
innodb/innodb_temp_file | 153 | 679431651888 | 4440729744 | 43942539168 | 0 | 43735334544 | 635696317344 | 0 | 0 | 0.0000 | 83 | 2670592 | 32175.8072 | |
sql/binlog | 211 | 307756709040 | 1458562512 | 61084278816 | 2852741232 | 2817538944 | 302086428864 | 43 | 768 | 17.8605 | 16 | 4254 | 265.8750 | |
sql/binlog_index | 38 | 48670696272 | 1280807616 | 26150281872 | 1726863072 | 0 | 46943833200 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 42589624704 | 709826832 | 5476056432 | 26129111184 | 0 | 16460513520 | 36 | 3685711 | 102380.8611 | 0 | 0 | 0.0000 | |
sql/io_cache | 50 | 2972902944 | 59457816 | 1649576016 | 190526688 | 885878400 | 1896497856 | 18 | 1294936 | 71940.8889 | 22 | 1294936 | 58860.7273 | |
sql/casetest | 15 | 747529728 | 49835280 | 687086400 | 0 | 0 | 747529728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 722962416 | 180740472 | 662815824 | 670867296 | 0 | 52095120 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 685700400 | 85712352 | 234596208 | 453191904 | 0 | 232508496 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 384900384 | 76980024 | 364775136 | 366097248 | 0 | 18803136 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 290393136 | 96797712 | 276241152 | 276241152 | 0 | 14151984 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 8 | 283719744 | 35464968 | 236004384 | 8929008 | 0 | 274790736 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 264303072 | 66075768 | 226157712 | 0 | 0 | 264303072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 99521136 | 33173712 | 73107936 | 0 | 22450560 | 77070576 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 26973936 | 13486968 | 25734192 | 0 | 0 | 26973936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|