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 | 1361 | 7115387308128 | 5228058264 | 76599297984 | 1329439056 | 173229595440 | 6940828273632 | 8 | 70656 | 8832.0000 | 852 | 1252864 | 1470.4977 | |
innodb/innodb_data_file | 3655 | 4982434306080 | 1363183008 | 224270116752 | 370297693392 | 68975634288 | 4543160978400 | 1591 | 31178752 | 19596.9529 | 1391 | 53395456 | 38386.3810 | |
innodb/innodb_temp_file | 162 | 761625494256 | 4701391728 | 29091533856 | 0 | 4828345104 | 756797149152 | 0 | 0 | 0.0000 | 80 | 3407872 | 42598.4000 | |
sql/binlog | 300 | 290650956816 | 968836440 | 28404805440 | 1628706288 | 1042778352 | 287979472176 | 63 | 848 | 13.4603 | 23 | 52330 | 2275.2174 | |
sql/binlog_index | 38 | 40364337552 | 1062219312 | 20807105616 | 1077895104 | 0 | 39286442448 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 34776799728 | 632305344 | 3517949952 | 21908367360 | 0 | 12868432368 | 33 | 3387243 | 102643.7273 | 0 | 0 | 0.0000 | |
sql/io_cache | 114 | 11860935504 | 104043192 | 6399805632 | 281000016 | 8340010272 | 3239925216 | 54 | 2496890 | 46238.7037 | 42 | 2496890 | 59449.7619 | |
myisam/dfile | 8311 | 5623445520 | 676368 | 1545031488 | 5444162064 | 0 | 179283456 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 4730553168 | 295659408 | 2683534656 | 4633629792 | 0 | 96923376 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1897460928 | 237182616 | 1241215536 | 1469238672 | 0 | 428222256 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 861041280 | 57402576 | 793168992 | 0 | 0 | 861041280 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 473373120 | 94674624 | 457567968 | 458826720 | 0 | 14546400 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 316857552 | 105619008 | 297413952 | 297413952 | 0 | 19443600 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 243686784 | 81228840 | 218863920 | 0 | 0 | 243686784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 83823696 | 20955792 | 45913824 | 0 | 0 | 83823696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48607680 | 16202472 | 37294752 | 0 | 8502912 | 40104768 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|