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 | 1531 | 7863026697504 | 5135876328 | 37966513200 | 1344595296 | 182218875168 | 7679463227040 | 8 | 70656 | 8832.0000 | 905 | 705024 | 779.0320 | |
innodb/innodb_data_file | 3650 | 3669530528928 | 1005350808 | 230358733440 | 214898747184 | 49238754048 | 3405393027696 | 1377 | 27672576 | 20096.2789 | 1835 | 67944448 | 37026.9471 | |
innodb/innodb_temp_file | 1175 | 1488663182688 | 1266947352 | 58998639216 | 0 | 99616309584 | 1389046873104 | 0 | 0 | 0.0000 | 1058 | 21725184 | 20534.2004 | |
sql/io_cache | 826 | 187555627776 | 227064816 | 127129271280 | 2178128304 | 13951104288 | 171426395184 | 360 | 19638814 | 54552.2611 | 336 | 19638814 | 58448.8512 | |
sql/binlog | 213 | 64473874608 | 302694216 | 17455792464 | 4114167552 | 517729872 | 59841977184 | 49 | 792 | 16.1633 | 5 | 591 | 118.2000 | |
sql/binlog_index | 38 | 53821200048 | 1416347328 | 35815364640 | 1567919232 | 0 | 52253280816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 30 | 24198249504 | 806608176 | 4023741744 | 12329428848 | 0 | 11868820656 | 18 | 1842241 | 102346.7222 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 9413016096 | 1176626880 | 8554132224 | 647152176 | 0 | 8765863920 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 14 | 1646799264 | 117628368 | 847356576 | 25997136 | 0 | 1620802128 | 4 | 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 |
|