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 | 3401 | 15068166006960 | 4430510304 | 99661886544 | 1463262768 | 437518792128 | 14629183952064 | 8 | 70656 | 8832.0000 | 2224 | 4082176 | 1835.5108 | |
innodb/innodb_data_file | 4574 | 6084376365936 | 1330208880 | 205952559120 | 261762865056 | 79411345200 | 5743202155680 | 1494 | 29589504 | 19805.5582 | 2131 | 78594048 | 36881.2989 | |
sql/binlog | 397 | 1038823949856 | 2616684840 | 27882002016 | 1912191072 | 1860747504 | 1035051011280 | 58 | 828 | 14.2759 | 79 | 25201 | 319.0000 | |
innodb/innodb_temp_file | 122 | 550287512016 | 4510553256 | 34568266656 | 0 | 3200781936 | 547086730080 | 0 | 0 | 0.0000 | 52 | 2162688 | 41590.1538 | |
sql/binlog_index | 38 | 47343803760 | 1245889392 | 23337068832 | 538253232 | 0 | 46805550528 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 22622596656 | 646359648 | 6600035376 | 14848710096 | 0 | 7773886560 | 21 | 2148387 | 102304.1429 | 0 | 0 | 0.0000 | |
myisam/kfile | 82 | 2624161584 | 32001816 | 1525979136 | 1556717184 | 83597184 | 983847216 | 12 | 2317 | 193.0833 | 34 | 1452 | 42.7059 | |
csv/metadata | 8 | 1033819248 | 129227208 | 585349776 | 792675312 | 0 | 241143936 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/SDI | 27 | 745998528 | 27629448 | 379207488 | 0 | 110999856 | 634998672 | 0 | 0 | 0.0000 | 7 | 30119 | 4302.7143 | |
sql/casetest | 15 | 709504752 | 47300088 | 650229888 | 0 | 0 | 709504752 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 700754208 | 140150736 | 661378608 | 662541264 | 0 | 38212944 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 46 | 473733744 | 10298376 | 256274304 | 8846112 | 42682464 | 422205168 | 8 | 2500 | 312.5000 | 6 | 3756 | 626.0000 | |
sql/misc | 9 | 381202272 | 42355632 | 252259392 | 0 | 0 | 381202272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 272248944 | 90749472 | 259484544 | 259484544 | 0 | 12764400 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 261194208 | 65298552 | 220626384 | 0 | 0 | 261194208 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46804032 | 15601344 | 36050784 | 0 | 7447440 | 39356592 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|