MySQL: Be wary of straight lines in performance graphs
MySQL: Be wary of straight lines in performance graphs
— Load is spiky, straight lines do not exist
— This is a general truth for our systems: In general our load is spiky. It has peaks and valleys, and there are no plateaus or straight lines (outside of Kafka and other Queues and the systems fed by them).
— That is, if you see a straight line, I see a resource being exhausted and limiting system performance.
— In this case, the exhausted resource is IOPS quota.
— In other cases in the past, a straight line in dirty buffer pool pages graph was signaling exhaustion of the redo log space, or similar performance choke points.
—
https://blog.koehntopp.info/2022/09/08/mysql-straight-lines.html
Subject
Views
Written By
Posted
MySQL: Be wary of straight lines in performance graphs
373
September 08, 2022 01: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.