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 | 1090 | 5905101734928 | 5417524464 | 50339903328 | 1300219536 | 160669545696 | 5743131969696 | 8 | 70656 | 8832.0000 | 648 | 665600 | 1027.1605 | |
innodb/innodb_data_file | 3196 | 3984493836048 | 1246712544 | 216499813728 | 238488249648 | 58869191568 | 3687136394832 | 1465 | 29114368 | 19873.2887 | 1267 | 49987584 | 39453.4996 | |
innodb/innodb_temp_file | 246 | 618298400016 | 2513408040 | 73640725488 | 0 | 88798962912 | 529499437104 | 0 | 0 | 0.0000 | 176 | 4194304 | 23831.2727 | |
sql/binlog | 297 | 236372996112 | 795868656 | 28360815648 | 2883508848 | 1428990288 | 232060496976 | 64 | 852 | 13.3125 | 17 | 4556 | 268.0000 | |
sql/binlog_index | 38 | 53304932208 | 1402761360 | 26011206144 | 1466168880 | 0 | 51838763328 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 42338544336 | 651362184 | 4074636720 | 20403886272 | 0 | 21934658064 | 39 | 3992068 | 102360.7179 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2429172240 | 151823232 | 760722336 | 2348170176 | 0 | 81002064 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/io_cache | 98 | 2236066800 | 22816992 | 301288944 | 203711904 | 1639605264 | 392749632 | 52 | 2226960 | 42826.1538 | 36 | 2226960 | 61860.0000 | |
sql/casetest | 15 | 778753008 | 51916656 | 711011664 | 0 | 0 | 778753008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 678259824 | 84782280 | 331370160 | 551470128 | 0 | 126789696 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 491764944 | 98352936 | 472421136 | 473838816 | 0 | 17926128 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 35 | 426779760 | 12193632 | 364319472 | 383391888 | 0 | 43387872 | 25 | 6525 | 261.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 332935152 | 110978208 | 316179600 | 316179600 | 0 | 16755552 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 236966928 | 59241600 | 202751472 | 0 | 0 | 236966928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 54036048 | 10807104 | 13643520 | 0 | 0 | 54036048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13805616 | 4601784 | 9489744 | 0 | 3655872 | 10149744 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|