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
639
August 09, 2021 05:01PM
Re: IOPS %100
328
August 09, 2021 08:57PM
273
September 24, 2021 05:21AM
253
November 15, 2021 04:48AM
289
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.