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 | 2462 | 10424949438288 | 4234341672 | 76510713840 | 1251466128 | 350077551648 | 10073620420512 | 8 | 70656 | 8832.0000 | 1640 | 2563584 | 1563.1610 | |
innodb/innodb_data_file | 4287 | 4839829354272 | 1128954816 | 177507452496 | 319661606880 | 98348810208 | 4421818937184 | 1492 | 29556736 | 19810.1448 | 1988 | 72400896 | 36418.9618 | |
innodb/innodb_temp_file | 526 | 1204056956256 | 2289081432 | 34930062816 | 0 | 35436344592 | 1168620611664 | 0 | 0 | 0.0000 | 418 | 10649600 | 25477.5120 | |
sql/binlog | 309 | 492695637456 | 1594484232 | 48729560352 | 1309464288 | 4780856256 | 486605316912 | 58 | 828 | 14.2759 | 35 | 6767 | 193.3429 | |
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/io_cache | 328 | 17127280368 | 52217088 | 5169586752 | 659496816 | 4689825888 | 11777957664 | 131 | 8091830 | 61769.6947 | 142 | 8087456 | 56953.9155 | |
mysys/cnf | 5 | 2940380256 | 588075840 | 2920684800 | 2922087168 | 0 | 18293088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 24 | 2797725744 | 116571840 | 718390992 | 2222459184 | 0 | 575266560 | 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 | 98 | 379383312 | 3871032 | 238591056 | 249909264 | 0 | 129474048 | 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/misc | 2 | 15278736 | 7639368 | 11039952 | 0 | 0 | 15278736 | 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 |
|