Comments - Which disk does innodb_io_capacity impact?

2 years, 2 months ago Oli Sennhauser

"innodb_io_capacity and innodb_io_capacity_max control the InnoDB background tasks activity, including merging data from the insert buffer and flushing pages."

The innodb background task flushes dirty blocks from InnoDB buffer pool to disk. These dirty blocks can be blocks from tables or indexes or the double write buffer? Those are located either in ibdata? or in all *.ibd files. So it is relevant where those files are located...

So in your case I think it is the RAID array.

2 years, 2 months ago Steve Hambling

Thanks Oli, That's exactly what I was looking for.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.