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 | 931 | 5940468999696 | 6380739816 | 606311815824 | 1468887024 | 617161876848 | 5321838235824 | 8 | 70656 | 8832.0000 | 550 | 429056 | 780.1018 | |
innodb/innodb_data_file | 2967 | 2493262797696 | 840331008 | 212105484624 | 281807985888 | 23977492176 | 2187477319632 | 1567 | 30785536 | 19646.1621 | 1048 | 43073536 | 41100.7023 | |
innodb/innodb_temp_file | 780 | 1600054876992 | 2051352336 | 523078155600 | 0 | 557289486336 | 1042765390656 | 0 | 0 | 0.0000 | 678 | 14516224 | 21410.3599 | |
sql/binlog | 266 | 76469630688 | 287479632 | 15815939568 | 3184512672 | 543777696 | 72741340320 | 63 | 995 | 15.7937 | 5 | 667 | 133.4000 | |
sql/binlog_index | 38 | 51093437472 | 1344564144 | 33556398480 | 1513425408 | 0 | 49580012064 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 648 | 46635976464 | 71969040 | 19854323808 | 1481710560 | 7691619936 | 37462645968 | 336 | 15126832 | 45020.3333 | 252 | 15126832 | 60027.1111 | |
sql/ERRMSG | 60 | 37640992224 | 627349800 | 5760901872 | 23189601600 | 0 | 14451390624 | 36 | 3686474 | 102402.0556 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1329204096 | 265840608 | 1311682416 | 1312883616 | 0 | 16320480 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 1182726864 | 147840792 | 646831680 | 1144795872 | 0 | 37930992 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 853153488 | 56876688 | 783241536 | 0 | 0 | 853153488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 501489648 | 125372280 | 435771072 | 435771072 | 0 | 65718576 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 7 | 345314112 | 49330512 | 303902016 | 306266400 | 0 | 39047712 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 194306640 | 64768704 | 180987312 | 180987312 | 0 | 13319328 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 40312272 | 13437336 | 26147616 | 0 | 0 | 40312272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 17387568 | 4346760 | 9474960 | 0 | 0 | 17387568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14643024 | 4880832 | 12215280 | 0 | 1807872 | 12835152 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|