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 | 1024 | 5756940451152 | 5622012000 | 117426295008 | 1260190272 | 139201701408 | 5616478559472 | 8 | 70656 | 8832.0000 | 609 | 553472 | 908.8210 | |
innodb/innodb_data_file | 2892 | 3839921926896 | 1327773744 | 215553644064 | 225677178672 | 52835245056 | 3561409503168 | 1348 | 27197440 | 20176.1424 | 1109 | 44548096 | 40169.6087 | |
innodb/innodb_temp_file | 358 | 1076889670032 | 3008071704 | 332849750640 | 0 | 534319673712 | 542569996320 | 0 | 0 | 0.0000 | 289 | 5980160 | 20692.5952 | |
sql/binlog | 263 | 227951602032 | 866736024 | 29970166512 | 1160966928 | 1300123968 | 225490511136 | 56 | 820 | 14.6429 | 16 | 3829 | 239.3125 | |
sql/binlog_index | 38 | 60711997632 | 1597683912 | 35026381632 | 1320537504 | 0 | 59391460128 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 47578266384 | 792970992 | 4096295808 | 29352796176 | 0 | 18225470208 | 36 | 3686637 | 102406.5833 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 4225693296 | 352140888 | 2473712736 | 4065273168 | 0 | 160420128 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2451382560 | 306422688 | 1248840384 | 1799570256 | 0 | 651812304 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 868003488 | 57866688 | 799894128 | 0 | 0 | 868003488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 521988720 | 104397744 | 482030736 | 483617904 | 0 | 38370816 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 341181984 | 56863488 | 145204752 | 0 | 0 | 341181984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 279557520 | 93185664 | 264492624 | 264492624 | 0 | 15064896 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 151463136 | 37865784 | 77835120 | 0 | 0 | 151463136 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 10 | 120932592 | 12093048 | 39656496 | 0 | 0 | 120932592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 19169568 | 6389856 | 14660976 | 0 | 3304752 | 15864816 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|