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_data_file | 1509 | 703996732560 | 466531824 | 236989496832 | 189678212064 | 36251837952 | 478066682544 | 1159 | 24100864 | 20794.5332 | 189 | 16105472 | 85214.1376 | |
innodb/innodb_log_file | 85 | 399682640544 | 4702148616 | 69460488768 | 1398534720 | 1351575456 | 396932530368 | 8 | 70656 | 8832.0000 | 44 | 66048 | 1501.0909 | |
innodb/innodb_temp_file | 90 | 372846333024 | 4142736840 | 28895705520 | 0 | 3086635728 | 369759697296 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 52519085520 | 1382081184 | 32431751616 | 1801279920 | 0 | 50717805600 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 65 | 36025888272 | 554244240 | 17042975664 | 880343376 | 72113184 | 35073431712 | 13 | 648 | 49.8462 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 14219922288 | 568796712 | 2325015792 | 8344727952 | 0 | 5875194336 | 15 | 1538911 | 102594.0667 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1484811504 | 296962248 | 1459366656 | 1461674544 | 0 | 23136960 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1296065760 | 86404296 | 1223740848 | 0 | 0 | 1296065760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 340026192 | 113342064 | 320246784 | 320246784 | 0 | 19779408 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47488848 | 15829440 | 37332240 | 0 | 7204560 | 40284288 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13064304 | 13064304 | 13064304 | 0 | 0 | 13064304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|