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 | 907 | 5285598549792 | 5827561608 | 390494404608 | 1930543296 | 256607974128 | 5027060032368 | 8 | 70656 | 8832.0000 | 576 | 940032 | 1632.0000 | |
innodb/innodb_data_file | 2349 | 3471717749808 | 1477955424 | 224988546816 | 218323624992 | 64027245216 | 3189366879600 | 1182 | 24477696 | 20708.7107 | 786 | 35864576 | 45629.2316 | |
innodb/innodb_temp_file | 105 | 462004475328 | 4400042592 | 41453083056 | 0 | 2589868512 | 459414606816 | 0 | 0 | 0.0000 | 41 | 1589248 | 38762.1463 | |
sql/binlog | 242 | 399593485632 | 1651212552 | 31319099328 | 812474256 | 1632039552 | 397148971824 | 46 | 927 | 20.1522 | 27 | 8491 | 314.4815 | |
sql/binlog_index | 38 | 51802032480 | 1363211256 | 32058328368 | 378331008 | 0 | 51423701472 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 24523856544 | 700681608 | 2935872720 | 14395748400 | 0 | 10128108144 | 21 | 2145061 | 102145.7619 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 3292047264 | 658409400 | 3275252112 | 3276422160 | 0 | 15625104 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 1083064752 | 36102000 | 600916800 | 42141792 | 297134640 | 743788320 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
sql/casetest | 15 | 879414624 | 58627536 | 812650080 | 0 | 0 | 879414624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 280023744 | 93341160 | 261075936 | 261075936 | 0 | 18947808 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46465584 | 15488352 | 36759888 | 0 | 7066752 | 39398832 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 31442400 | 10480800 | 12673584 | 0 | 0 | 31442400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|