Re: What is InnoDB Reading and Writing when It's Idle?

[Authorized User]

Here again, this is hours after the benchmark completed, and MySQL is still doing a lot of reading and writing.

[root@ha50a ~]# iotop -o
Total DISK READ : 4.39 M/s | Total DISK WRITE : 3.17 M/s
Actual DISK READ: 1369.04 K/s | Actual DISK WRITE: 27.50 M/s
TID PRIO USER DISK READ DISK WRITE SWAPIN IO> COMMAND
89215 be/4 root 0.00 B/s 0.00 B/s 0.00 % 3.93 % [txg_sync]
3016188 be/4 mysql 895.33 K/s 0.00 B/s 0.00 % 0.16 % mysqld
3016187 be/4 mysql 522.04 K/s 0.00 B/s 0.00 % 0.16 % mysqld
3016192 be/4 mysql 451.93 K/s 0.00 B/s 0.00 % 0.13 % mysqld
3016191 be/4 mysql 419.71 K/s 0.00 B/s 0.00 % 0.11 % mysqld
3016193 be/4 mysql 468.03 K/s 0.00 B/s 0.00 % 0.11 % mysqld
3016186 be/4 mysql 600.67 K/s 0.00 B/s 0.00 % 0.11 % mysqld
3016194 be/4 mysql 430.14 K/s 0.00 B/s 0.00 % 0.10 % mysqld
3016185 be/4 mysql 277.60 K/s 0.00 B/s 0.00 % 0.10 % mysqld

The files are ones that were used during the benchmark...

Bytes Filename
--------------------------------------------------------------------------------
1.58M /zpool0/sysbench/data/sysbench/order_line2.ibd
1.44M /zpool0/sysbench/data/sysbench/order_line5.ibd
816.00KB /zpool0/sysbench/data/sysbench/order_line9.ibd
720.00KB /zpool0/sysbench/data/sysbench/order_line1.ibd
528.00KB /zpool0/sysbench/data/sysbench/order_line4.ibd
448.00KB /zpool0/sysbench/data/sysbench/order_line7.ibd
256.00KB /zpool0/sysbench/data/sysbench/order_line8.ibd
160.00KB /zpool0/sysbench/data/ibdata1
144.00KB /zpool0/sysbench/data/sysbench/history3.ibd
112.00KB /zpool0/sysbench/data/sysbench/history6.ibd