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 | 3459 | 18580894896432 | 5371753200 | 275769921504 | 1269729120 | 755154322032 | 17824470845280 | 8 | 70656 | 8832.0000 | 2199 | 2977280 | 1353.9245 | |
innodb/innodb_data_file | 5281 | 10198306853856 | 1931131752 | 293455665888 | 344338819968 | 171441511296 | 9682526522592 | 1599 | 31309824 | 19580.8780 | 2616 | 93241344 | 35642.7156 | |
sql/binlog | 949 | 2445616142640 | 2577045240 | 36272093616 | 2294841120 | 11223592512 | 2432097709008 | 150 | 1196 | 7.9733 | 171 | 58578 | 342.5614 | |
innodb/innodb_temp_file | 114 | 550408047024 | 4828140504 | 37386295056 | 0 | 3443834064 | 546964212960 | 0 | 0 | 0.0000 | 47 | 1884160 | 40088.5106 | |
sql/ERRMSG | 80 | 52127088816 | 651588432 | 4418422272 | 29298312912 | 0 | 22828775904 | 48 | 4912111 | 102335.6458 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 42213142224 | 1110872136 | 24221401776 | 953006208 | 0 | 41260136016 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 15285507072 | 1910688384 | 10825816848 | 2533668192 | 0 | 12751838880 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 12 | 2684233728 | 223686144 | 2007973968 | 405549936 | 0 | 2278683792 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 1462064736 | 121838640 | 550711392 | 1396983984 | 0 | 65080752 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1042968960 | 69531264 | 985233216 | 0 | 0 | 1042968960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 667676592 | 133535160 | 637329792 | 639298704 | 0 | 28377888 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 37 | 466324848 | 12603360 | 389407392 | 395186880 | 0 | 71137968 | 25 | 1675 | 67.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 274623888 | 91541208 | 264225456 | 264225456 | 0 | 10398432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 139334448 | 15481488 | 32025312 | 0 | 0 | 139334448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 22614240 | 7537992 | 15075984 | 0 | 6195552 | 16418688 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|