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 | 462 | 2777300876064 | 6011473512 | 117397966224 | 1563639792 | 212700782976 | 2563036453296 | 8 | 70656 | 8832.0000 | 275 | 328704 | 1195.2873 | |
innodb/innodb_data_file | 2099 | 1873879814400 | 892748736 | 222961337808 | 509635692192 | 36002562816 | 1328241559392 | 1279 | 26066944 | 20380.7224 | 562 | 28229632 | 50230.6619 | |
innodb/innodb_temp_file | 179 | 664117097952 | 3710151192 | 36457674528 | 0 | 30105111168 | 634011986784 | 0 | 0 | 0.0000 | 108 | 3145728 | 29127.1111 | |
sql/binlog | 73 | 124319511888 | 1703006976 | 24927301872 | 3577585440 | 1044951072 | 119696975376 | 12 | 644 | 53.6667 | 9 | 2051 | 227.8889 | |
sql/binlog_index | 38 | 58457567520 | 1538357040 | 41022546576 | 1494270624 | 0 | 56963296896 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 15239123856 | 435403320 | 1960301904 | 8403637968 | 0 | 6835485888 | 21 | 2138281 | 101822.9048 | 0 | 0 | 0.0000 | |
sql/io_cache | 105 | 12475209648 | 118811352 | 5491645632 | 353401488 | 2063050704 | 10058757456 | 38 | 2754832 | 72495.5789 | 47 | 2754832 | 58613.4468 | |
sql/casetest | 15 | 983535168 | 65568888 | 919182000 | 0 | 0 | 983535168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 681436272 | 136287096 | 655788144 | 657075408 | 0 | 24360864 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 277080144 | 92359872 | 237049824 | 237049824 | 0 | 40030320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 38284224 | 12761232 | 13207392 | 0 | 0 | 38284224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14126640 | 4708704 | 9380448 | 0 | 3822192 | 10304448 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|