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
1158
August 09, 2021 05:01PM
Re: IOPS %100
549
August 09, 2021 08:57PM
486
September 24, 2021 05:21AM
492
November 15, 2021 04:48AM
496
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.