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 | 605 | 3320693324784 | 5488749288 | 98320923360 | 1339622592 | 57938216688 | 3261415485504 | 8 | 70656 | 8832.0000 | 352 | 340992 | 968.7273 | |
innodb/innodb_data_file | 2614 | 2571934312464 | 983907408 | 220708028112 | 273812315568 | 45991944768 | 2252130052128 | 1483 | 29409280 | 19830.9373 | 767 | 34062336 | 44409.8253 | |
innodb/innodb_temp_file | 187 | 1673122204512 | 8947177536 | 913424651568 | 0 | 923711710416 | 749410494096 | 0 | 0 | 0.0000 | 109 | 3620864 | 33218.9358 | |
sql/binlog | 213 | 104770402176 | 491879784 | 20437034112 | 1490392992 | 2351558880 | 100928450304 | 48 | 788 | 16.4167 | 7 | 1229 | 175.5714 | |
sql/binlog_index | 38 | 63511642656 | 1671358920 | 38387382000 | 865843440 | 0 | 62645799216 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 33195460848 | 663909048 | 4287739104 | 16999731936 | 0 | 16195728912 | 30 | 3082764 | 102758.8000 | 0 | 0 | 0.0000 | |
sql/io_cache | 96 | 8406953280 | 87572232 | 6560282256 | 377284512 | 1215274896 | 6814393872 | 48 | 2272324 | 47340.0833 | 38 | 2272324 | 59798.0000 | |
csv/metadata | 8 | 2503386336 | 312923160 | 1492409952 | 883841904 | 0 | 1619544432 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 732416256 | 146483040 | 707747040 | 709981008 | 0 | 22435248 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 725079168 | 48338400 | 663415632 | 0 | 0 | 725079168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 515696016 | 128923872 | 478974144 | 0 | 0 | 515696016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 262134576 | 87378192 | 247961472 | 247961472 | 0 | 14173104 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 55049280 | 18349584 | 34053888 | 0 | 17920320 | 37128960 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 49702224 | 16567320 | 30396432 | 0 | 0 | 49702224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|