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 | 906 | 5131476136512 | 5663880816 | 44017917504 | 1391951088 | 105740072592 | 5024344112832 | 8 | 70656 | 8832.0000 | 533 | 559616 | 1049.9362 | |
innodb/innodb_data_file | 3186 | 4114366851408 | 1291389264 | 195568446480 | 207425293152 | 45153830304 | 3861787727952 | 1424 | 28442624 | 19973.7528 | 1217 | 47923200 | 39378.1430 | |
innodb/innodb_temp_file | 102 | 368801241600 | 3615698328 | 24107939328 | 0 | 1301286096 | 367499955504 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | |
sql/binlog | 293 | 204743616528 | 698783448 | 23262710064 | 802533600 | 1046412048 | 202894670880 | 65 | 856 | 13.1692 | 13 | 2568 | 197.5385 | |
sql/ERRMSG | 95 | 52722387696 | 554972352 | 6574846608 | 35979302304 | 0 | 16743085392 | 57 | 5825125 | 102195.1754 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 47114025552 | 1239842736 | 30449341296 | 1507453200 | 0 | 45606572352 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1426862448 | 285372384 | 1405087200 | 1406670672 | 0 | 20191776 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1119224304 | 74614848 | 997694544 | 0 | 0 | 1119224304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 452864544 | 56607936 | 241061568 | 412753968 | 0 | 40110576 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
myisam/dfile | 6 | 313812048 | 52301832 | 288986016 | 288986016 | 0 | 24826032 | 1 | 67 | 67.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 253029744 | 84343248 | 234625248 | 234625248 | 0 | 18404496 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 63376896 | 21125544 | 30647760 | 0 | 0 | 63376896 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13493568 | 4497768 | 10810800 | 0 | 2112000 | 11381568 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|