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
516
August 09, 2021 05:01PM
Re: IOPS %100
257
August 09, 2021 08:57PM
205
September 24, 2021 05:21AM
168
November 15, 2021 04:48AM
210
November 14, 2021 06:02PM


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.