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
300
August 09, 2021 05:01PM
Re: IOPS %100
109
August 09, 2021 08:57PM
70
September 24, 2021 05:21AM
51
November 15, 2021 04:48AM
76
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.