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
902
December 14, 2021 09:04PM
Re: What is InnoDB Reading and Writing when It's Idle?
497
December 15, 2021 05:57AM
420
December 15, 2021 10:45AM
439
December 15, 2021 11:12AM
378
December 15, 2021 11:29AM
458
December 15, 2021 11:50AM
457
December 15, 2021 12:20PM
466
December 15, 2021 11:16AM
414
December 15, 2021 02:19PM
320
December 15, 2021 02:35PM
418
December 15, 2021 02:51PM
Sorry, you can't reply to this topic. It has been closed.
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.