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 | 620 | 3768126513888 | 6077623200 | 209992142448 | 1672430496 | 76241320320 | 3690212763072 | 8 | 70656 | 8832.0000 | 354 | 288256 | 814.2825 | |
innodb/innodb_data_file | 2664 | 2882821287984 | 1082139960 | 252100929696 | 305608265952 | 42723921504 | 2534489100528 | 1488 | 29491200 | 19819.3548 | 798 | 34619392 | 43382.6967 | |
innodb/innodb_temp_file | 531 | 1514272075008 | 2851736448 | 159932383248 | 0 | 178244563200 | 1336027511808 | 0 | 0 | 0.0000 | 424 | 10682368 | 25194.2642 | |
sql/binlog_index | 38 | 66169256736 | 1741296216 | 47185489824 | 496160016 | 0 | 65673096720 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 325 | 46824832560 | 144076152 | 18954842016 | 8463812016 | 42171360 | 38318849184 | 78 | 908 | 11.6410 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 50 | 32253928608 | 645078456 | 6476389392 | 17959657056 | 0 | 14294271552 | 30 | 3075942 | 102531.4000 | 0 | 0 | 0.0000 | |
sql/io_cache | 282 | 10784290176 | 38241984 | 1535841120 | 858404448 | 5615392992 | 4310492736 | 116 | 6579060 | 56716.0345 | 116 | 6579060 | 56716.0345 | |
csv/metadata | 8 | 3482978400 | 435372168 | 1768639488 | 1474089408 | 0 | 2008888992 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 891353760 | 111419088 | 545425584 | 860485824 | 0 | 30867936 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 739703712 | 49313352 | 672273888 | 0 | 0 | 739703712 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 13 | 522321360 | 40178424 | 425733792 | 24511872 | 0 | 497809488 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 432002208 | 86400336 | 417426240 | 418322256 | 0 | 13679952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 252555072 | 84184848 | 239518752 | 239518752 | 0 | 13036320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 65652576 | 21884016 | 36223968 | 0 | 25412640 | 40239936 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 4 | 17181120 | 4295280 | 8739984 | 0 | 0 | 17181120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13091760 | 13091760 | 13091760 | 0 | 0 | 13091760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|