SELECT * FROM `io_global_by_file_by_latency`
|
file | total | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency | |
---|---|---|---|---|---|---|---|---|---|
@@datadir/ib_logfile1 | 1046 | 5.88 s | 2 | 766.91 us | 640 | 161.75 ms | 404 | 5.72 s | |
@@datadir/ibdata1 | 273 | 2.11 s | 20 | 5.44 ms | 129 | 15.10 ms | 124 | 2.09 s | |
@@datadir/ib_logfile0 | 127 | 844.96 ms | 6 | 427.55 us | 59 | 2.52 ms | 62 | 842.01 ms | |
@@datadir/mysql.ibd | 733 | 630.57 ms | 373 | 106.74 ms | 295 | 7.19 ms | 65 | 516.64 ms | |
@@datadir/undo_001 | 776 | 578.30 ms | 388 | 31.35 ms | 339 | 13.63 ms | 49 | 533.32 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 87 | 562.98 ms | 0 | 0 ps | 55 | 2.62 ms | 32 | 560.36 ms | |
@@datadir/undo_002 | 779 | 553.39 ms | 382 | 26.05 ms | 349 | 8.75 ms | 48 | 518.59 ms | |
@@datadir/binlog.000008 | 40 | 317.21 ms | 0 | 0 ps | 19 | 2.25 ms | 21 | 314.96 ms | |
@@datadir/ibtmp1 | 147 | 239.17 ms | 0 | 0 ps | 143 | 9.92 ms | 4 | 229.25 ms | |
@@datadir/taobao/OrderItem.ibd | 25 | 177.26 ms | 0 | 0 ps | 14 | 680.23 us | 11 | 176.58 ms | |
@@datadir/taobao/Payment.ibd | 27 | 170.35 ms | 0 | 0 ps | 16 | 179.90 us | 11 | 170.17 ms | |
@@datadir/taobao/Review.ibd | 17 | 92.24 ms | 0 | 0 ps | 9 | 406.94 us | 8 | 91.84 ms | |
@@datadir/uroejzhj/TransactionStatus.ibd | 17 | 90.47 ms | 0 | 0 ps | 9 | 430.86 us | 8 | 90.04 ms | |
@@datadir/Huda/sales.ibd | 15 | 73.82 ms | 0 | 0 ps | 8 | 542.33 us | 7 | 73.28 ms | |
@@datadir/uroejzhj/Account.ibd | 13 | 70.64 ms | 0 | 0 ps | 7 | 369.23 us | 6 | 70.27 ms | |
@@datadir/uroejzhj/Currency.ibd | 13 | 68.07 ms | 0 | 0 ps | 7 | 560.95 us | 6 | 67.51 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 61.92 ms | 0 | 0 ps | 3 | 69.28 us | 5 | 61.85 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 11 | 42.75 ms | 0 | 0 ps | 5 | 154.69 us | 6 | 42.60 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 35.46 ms | 0 | 0 ps | 3 | 54.93 us | 5 | 35.40 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 32.41 ms | 0 | 0 ps | 3 | 69.04 us | 5 | 32.34 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 32.00 ms | 0 | 0 ps | 3 | 62.26 us | 5 | 31.93 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 28.98 ms | 0 | 0 ps | 3 | 58.91 us | 5 | 28.92 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 27.93 ms | 0 | 0 ps | 3 | 63.46 us | 5 | 27.86 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 27.72 ms | 0 | 0 ps | 3 | 54.54 us | 5 | 27.66 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 26.74 ms | 0 | 0 ps | 3 | 60.15 us | 5 | 26.68 ms |
|