MySQL Forums
Forum List  »  Performance

MySQL: Be wary of straight lines in performance graphs
Posted by: Edwin Desouza
Date: September 08, 2022 01:02PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL: Be wary of straight lines in performance graphs
33
September 08, 2022 01: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.