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 | 1014 | 5232672642384 | 5160426480 | 57127459488 | 1251466128 | 154407926112 | 5077013250144 | 8 | 70656 | 8832.0000 | 596 | 474112 | 795.4899 | |
innodb/innodb_data_file | 3221 | 3635995381920 | 1128840504 | 177507452496 | 277940608704 | 73170757968 | 3284884015248 | 1438 | 28672000 | 19938.8039 | 1288 | 50184192 | 38962.8820 | |
innodb/innodb_temp_file | 426 | 1102503740976 | 2588036880 | 34930062816 | 0 | 34564593888 | 1067939147088 | 0 | 0 | 0.0000 | 323 | 8765440 | 27137.5851 | |
sql/binlog_index | 38 | 54885724080 | 1444361160 | 37811737392 | 247417104 | 0 | 54638306976 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 40723789392 | 814475640 | 9484481424 | 24391641120 | 0 | 16332148272 | 30 | 3071856 | 102395.2000 | 0 | 0 | 0.0000 | |
sql/binlog | 237 | 34951482720 | 147474360 | 15424925472 | 1303098192 | 24588960 | 33623795568 | 56 | 820 | 14.6429 | 3 | 156 | 52.0000 | |
sql/io_cache | 93 | 3993979440 | 42945936 | 1914040128 | 155944272 | 1538288400 | 2299746768 | 40 | 2155332 | 53883.3000 | 38 | 2150958 | 56604.1579 | |
mysys/cnf | 5 | 2940380256 | 588075840 | 2920684800 | 2922087168 | 0 | 18293088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2285040912 | 142815024 | 718390992 | 2222459184 | 0 | 62581728 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 866976000 | 57798312 | 790178400 | 0 | 0 | 866976000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 495798864 | 123949584 | 440354640 | 440354640 | 0 | 55444224 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 88 | 316425120 | 3595680 | 238591056 | 249909264 | 0 | 66515856 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 271076256 | 90358752 | 256241040 | 256241040 | 0 | 14835216 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 268563504 | 134281752 | 262550112 | 0 | 0 | 268563504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13808256 | 4602576 | 10735296 | 0 | 2341680 | 11466576 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 4238784 | 4238784 | 4238784 | 0 | 0 | 4238784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|