MySQL Forums
Forum List  »  InnoDB

Re: What is InnoDB Reading and Writing when It's Idle?
Posted by: Authorized User
Date: December 15, 2021 05:57AM

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

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.