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 | 1363 | 6944909340864 | 5095311144 | 37966513200 | 1344595296 | 144487494096 | 6799077251472 | 8 | 70656 | 8832.0000 | 806 | 638976 | 792.7742 | |
innodb/innodb_data_file | 3516 | 3383049145344 | 962186808 | 230358733440 | 212930905440 | 47863404336 | 3122254835568 | 1362 | 27426816 | 20137.1630 | 1741 | 65028096 | 37351.0029 | |
innodb/innodb_temp_file | 955 | 1247788257408 | 1306584312 | 58998639216 | 0 | 97496577024 | 1150291680384 | 0 | 0 | 0.0000 | 852 | 17432576 | 20460.7700 | |
sql/io_cache | 678 | 185243144064 | 273219936 | 127129271280 | 1895153040 | 12598116432 | 170749874592 | 292 | 16075678 | 55053.6918 | 276 | 16075678 | 58245.2101 | |
sql/binlog | 165 | 64241674992 | 389343240 | 17455792464 | 4081776336 | 517729872 | 59642168784 | 37 | 744 | 20.1081 | 5 | 591 | 118.2000 | |
sql/binlog_index | 38 | 53821200048 | 1416347328 | 35815364640 | 1567919232 | 0 | 52253280816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 25 | 17925923664 | 717036936 | 3462545328 | 10094293440 | 0 | 7831630224 | 15 | 1535694 | 102379.6000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 9413016096 | 1176626880 | 8554132224 | 647152176 | 0 | 8765863920 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 1582769232 | 395692176 | 847356576 | 0 | 0 | 1582769232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 890187408 | 59345616 | 788670960 | 0 | 0 | 890187408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 859982640 | 171996528 | 831023952 | 832502880 | 0 | 27479760 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 247294080 | 82431360 | 227166192 | 227166192 | 0 | 20127888 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 42854592 | 14284776 | 17484192 | 0 | 0 | 42854592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 22796928 | 7598976 | 18620976 | 0 | 3082464 | 19714464 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|