Re: What is InnoDB Reading and Writing when It's Idle?
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
Subject
Views
Written By
Posted
225
December 14, 2021 09:04PM
Re: What is InnoDB Reading and Writing when It's Idle?
200
December 15, 2021 05:57AM
120
December 15, 2021 10:45AM
130
December 15, 2021 11:12AM
116
December 15, 2021 11:29AM
174
December 15, 2021 11:50AM
150
December 15, 2021 12:20PM
181
December 15, 2021 11:16AM
116
December 15, 2021 02:19PM
94
December 15, 2021 02:35PM
124
December 15, 2021 02:51PM
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.