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 | 6819 | 32966812697808 | 4834552272 | 120519114672 | 1355798400 | 1045780121232 | 31919676778176 | 8 | 70656 | 8832.0000 | 4490 | 7403008 | 1648.7768 | |
innodb/innodb_data_file | 7920 | 14860715164944 | 1876352808 | 243385153968 | 340967017776 | 233579055600 | 14286169091568 | 1547 | 30457856 | 19688.3361 | 4479 | 152911872 | 34139.7348 | |
sql/binlog | 827 | 2146094903568 | 2595036048 | 38528658432 | 804368400 | 15319374576 | 2129971160592 | 131 | 1120 | 8.5496 | 149 | 74416 | 499.4362 | |
innodb/innodb_temp_file | 131 | 507937653696 | 3877386480 | 31292079456 | 0 | 2078753952 | 505858899744 | 0 | 0 | 0.0000 | 60 | 2359296 | 39321.6000 | |
sql/binlog_index | 38 | 51444250176 | 1353795960 | 29137519488 | 519955920 | 0 | 50924294256 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 46726663632 | 718871736 | 5013934992 | 29681627712 | 0 | 17045035920 | 39 | 3997924 | 102510.8718 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3162686208 | 395335776 | 1928786640 | 941359056 | 0 | 2221327152 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 14 | 2708222880 | 193444416 | 2195664768 | 2432320176 | 0 | 275902704 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1961072256 | 392214240 | 1944013104 | 1945159920 | 0 | 15912336 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 60 | 1830135648 | 30502032 | 512969952 | 157227840 | 701017152 | 971890656 | 16 | 1115648 | 69728.0000 | 24 | 1098152 | 45756.3333 | |
csv/data | 40 | 759749232 | 18993480 | 467437872 | 523291824 | 0 | 236457408 | 16 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 737784960 | 49185576 | 655141344 | 0 | 0 | 737784960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 23 | 697410912 | 30321984 | 465594096 | 0 | 0 | 697410912 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 314182176 | 104727216 | 298867536 | 298867536 | 0 | 15314640 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 10 | 306918480 | 30691848 | 260975616 | 0 | 0 | 306918480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12233232 | 4077744 | 9910560 | 0 | 1705968 | 10527264 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|