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 | 3256 | 17632245197952 | 5415308712 | 158342062560 | 1278600576 | 611010758160 | 17019955839216 | 8 | 70656 | 8832.0000 | 2065 | 2991616 | 1448.7245 | |
innodb/innodb_data_file | 4672 | 9154206423648 | 1959376320 | 240921342288 | 374037649392 | 167829586848 | 8612339187408 | 1511 | 29868032 | 19767.0629 | 2203 | 80330752 | 36464.2542 | |
sql/binlog | 542 | 824020564752 | 1520332968 | 33133161600 | 1312676640 | 12367022448 | 810340865664 | 107 | 1171 | 10.9439 | 55 | 20077 | 365.0364 | |
innodb/innodb_temp_file | 93 | 343737067344 | 3696097416 | 24018608064 | 0 | 927238224 | 342809829120 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | |
sql/io_cache | 100 | 89291171904 | 892911624 | 85760888400 | 349679616 | 2821132512 | 86120359776 | 50 | 2420788 | 48415.7600 | 40 | 2420788 | 60519.7000 | |
sql/binlog_index | 38 | 53865346128 | 1417508928 | 29695612848 | 491796624 | 0 | 53373549504 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 75 | 42858538272 | 571447008 | 3649562400 | 25390565376 | 0 | 17467972896 | 45 | 4607110 | 102380.2222 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4291449360 | 536431104 | 2145597696 | 1821697152 | 0 | 2469752208 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 4182700368 | 261418608 | 1705343376 | 4108484688 | 0 | 74215680 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1414599120 | 282919824 | 1394431632 | 1395605376 | 0 | 18993744 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 12 | 917110128 | 76425624 | 664013328 | 0 | 0 | 917110128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 825783024 | 55052184 | 753272784 | 0 | 0 | 825783024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 15 | 336576240 | 22438416 | 73673424 | 116867520 | 0 | 219708720 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 87 | 333091440 | 3828528 | 251670672 | 262732272 | 0 | 70359168 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 243230592 | 81076776 | 228088080 | 228088080 | 0 | 15142512 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13728528 | 4576176 | 11288640 | 0 | 1794144 | 11934384 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|