MySQL Forums
Forum List  »  Performance

Re: IOPS %100
Posted by: Peter Brawley
Date: August 09, 2021 08:57PM

What's the IOPS capacity of your system?

MySQL version?

Are flushes falling behind?

What's the result of ...

show variables like 'innodb_io%';
show variables like 'innodb_flush%';

.. and of computing ...

( Innodb_pages_read + Innodb_pages_written +
Innodb_dblwr_writes + Innodb_buffer_pool_pages_flushed ) / Uptime

... over a busy period?

Have you reviewed https://dev.mysql.com/doc/refman/8.0/en/innodb-configuring-io-capacity.html ?

Options: ReplyQuote


Subject
Views
Written By
Posted
205
August 09, 2021 05:01PM
Re: IOPS %100
89
August 09, 2021 08:57PM
44
September 24, 2021 05:21AM
19
November 15, 2021 04:48AM
18
November 14, 2021 06:02PM


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.