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 | 894 | 5207539979136 | 5824988664 | 88285772256 | 1455663264 | 170865249984 | 5035219065888 | 8 | 70656 | 8832.0000 | 527 | 492032 | 933.6471 | |
innodb/innodb_data_file | 3143 | 4525446162864 | 1439849136 | 219468580320 | 260898085536 | 49312480800 | 4215235596528 | 1537 | 30294016 | 19709.8347 | 1057 | 42319872 | 40037.7219 | |
innodb/innodb_temp_file | 399 | 1914479807856 | 4798194984 | 521339421504 | 0 | 540697856160 | 1373781951696 | 0 | 0 | 0.0000 | 307 | 7782400 | 25349.8371 | |
sql/binlog | 307 | 146372259792 | 476782416 | 24275209728 | 2669337264 | 6264634992 | 137438287536 | 71 | 880 | 12.3944 | 8 | 1740 | 217.5000 | |
sql/binlog_index | 38 | 47285612880 | 1244358192 | 28797153264 | 587958096 | 0 | 46697654784 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 637 | 39215118624 | 61562160 | 11412568464 | 1384240704 | 15031973088 | 22798904832 | 207 | 15340712 | 74109.7198 | 280 | 15336338 | 54772.6357 | |
sql/ERRMSG | 45 | 31514392272 | 700319664 | 4757690784 | 17961409488 | 0 | 13552982784 | 27 | 2756805 | 102103.8889 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1933883952 | 386776632 | 1911620304 | 1914007920 | 0 | 19876032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 1339644768 | 446548080 | 1299139248 | 0 | 0 | 1339644768 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1336965696 | 167120712 | 488656080 | 793206480 | 0 | 543759216 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1032729456 | 68848560 | 974439312 | 0 | 0 | 1032729456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 589698384 | 147424464 | 490972944 | 0 | 0 | 589698384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 459690000 | 57461184 | 220422048 | 433557696 | 0 | 26132304 | 4 | 854 | 213.5000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 249024864 | 83008200 | 224361984 | 224361984 | 0 | 24662880 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 55858176 | 18619392 | 35916144 | 0 | 16795680 | 39062496 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 5 | 22844976 | 4568784 | 9312864 | 0 | 0 | 22844976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|