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 | 762 | 4415142165456 | 5794149768 | 68441111376 | 1629910128 | 217897489920 | 4195614765408 | 8 | 70656 | 8832.0000 | 447 | 374784 | 838.4430 | |
innodb/innodb_data_file | 2693 | 2740588939440 | 1017671160 | 245722290528 | 266431329120 | 43959324288 | 2430198286032 | 1319 | 26722304 | 20259.5178 | 1001 | 41304064 | 41262.8012 | |
innodb/innodb_temp_file | 236 | 1206101258736 | 5110598328 | 639797490288 | 0 | 651873021360 | 554228237376 | 0 | 0 | 0.0000 | 168 | 3932160 | 23405.7143 | |
sql/binlog | 251 | 105104310432 | 418742016 | 24551762400 | 858427680 | 2451455424 | 101794427328 | 58 | 828 | 14.2759 | 6 | 882 | 147.0000 | |
sql/binlog_index | 38 | 58707549120 | 1544935392 | 35885627184 | 1218257568 | 0 | 57489291552 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 36511819344 | 608530296 | 3771919008 | 20674970448 | 0 | 15836848896 | 36 | 3685999 | 102388.8611 | 0 | 0 | 0.0000 | |
sql/io_cache | 112 | 4321088112 | 38580960 | 1631198976 | 243572208 | 1323849648 | 2753666256 | 40 | 2977528 | 74438.2000 | 52 | 2977528 | 57260.1538 | |
sql/casetest | 15 | 1118989344 | 74599272 | 1060058736 | 0 | 0 | 1118989344 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 7 | 677518512 | 96788208 | 444379056 | 447640512 | 0 | 229878000 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 650229888 | 130045872 | 632027088 | 633315936 | 0 | 16913952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 396801504 | 99200376 | 345324144 | 345324144 | 0 | 51477360 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 312624048 | 104207928 | 296586048 | 296586048 | 0 | 16038000 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 226385808 | 56596320 | 188579424 | 0 | 0 | 226385808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 50309952 | 16769808 | 39431040 | 0 | 8041440 | 42268512 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|