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 | 500 | 2836363283424 | 5672726400 | 99384040272 | 1403296224 | 68720852640 | 2766239134560 | 8 | 70656 | 8832.0000 | 291 | 245760 | 844.5361 | |
innodb/innodb_data_file | 2281 | 2162437552176 | 948021624 | 231632174400 | 202064927856 | 32982173136 | 1927390451184 | 1323 | 26787840 | 20247.8005 | 666 | 30818304 | 46273.7297 | |
innodb/innodb_temp_file | 176 | 929078418048 | 5278854504 | 47611710960 | 0 | 3615156336 | 925463261712 | 0 | 0 | 0.0000 | 89 | 3883008 | 43629.3034 | |
sql/binlog | 279 | 110406296880 | 395721480 | 18221257296 | 951705744 | 1012493856 | 108442097280 | 64 | 852 | 13.3125 | 8 | 1428 | 178.5000 | |
sql/io_cache | 170 | 62202150384 | 365894760 | 51438713568 | 492911232 | 2716672992 | 58992566160 | 68 | 4128124 | 60707.7059 | 72 | 4128124 | 57335.0556 | |
sql/binlog_index | 38 | 58147717056 | 1530202872 | 40962497664 | 1757149680 | 0 | 56390567376 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 23083121952 | 577077864 | 2351808624 | 14422341120 | 0 | 8660780832 | 24 | 2464019 | 102667.4583 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2597737296 | 324717096 | 1836673344 | 671170896 | 0 | 1926566400 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 733572048 | 48904680 | 661744512 | 0 | 0 | 733572048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 543157824 | 67894728 | 308175648 | 509962464 | 0 | 33195360 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 510498384 | 102099624 | 491481936 | 492781872 | 0 | 17716512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 4 | 288516096 | 72129024 | 256695648 | 0 | 0 | 288516096 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 270584688 | 90194808 | 250533360 | 250533360 | 0 | 20051328 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 98954064 | 16492344 | 30614496 | 0 | 0 | 98954064 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18148944 | 6049560 | 10285968 | 0 | 7107408 | 11041536 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 4 | 16279296 | 4069824 | 8999760 | 0 | 0 | 16279296 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|