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 | 1476 | 8984922295536 | 6087345528 | 390494404608 | 1930543296 | 321081602160 | 8661910150080 | 8 | 70656 | 8832.0000 | 910 | 1255424 | 1379.5868 | |
innodb/innodb_data_file | 3270 | 6384334470624 | 1952395632 | 224988546816 | 306292020144 | 89247325728 | 5988795124752 | 1285 | 26165248 | 20362.0607 | 1319 | 51625984 | 39140.2456 | |
innodb/innodb_temp_file | 111 | 517426971600 | 4661504232 | 41453083056 | 0 | 2806718640 | 514620252960 | 0 | 0 | 0.0000 | 45 | 1785856 | 39685.6889 | |
sql/binlog | 408 | 480425192544 | 1177512600 | 31319099328 | 917882592 | 2305239552 | 477202070400 | 85 | 1083 | 12.7412 | 32 | 10443 | 326.3438 | |
sql/binlog_index | 38 | 51802032480 | 1363211256 | 32058328368 | 378331008 | 0 | 51423701472 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 33441413280 | 743142312 | 3428419104 | 19405538064 | 0 | 14035875216 | 27 | 2769120 | 102560.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 126 | 3422667600 | 27164016 | 600916800 | 244357344 | 1393750512 | 1784559744 | 46 | 2684830 | 58365.8696 | 50 | 2667334 | 53346.6800 | |
mysys/cnf | 5 | 3292047264 | 658409400 | 3275252112 | 3276422160 | 0 | 15625104 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 2115607296 | 528901824 | 2084164896 | 0 | 0 | 2115607296 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
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 |
|