MySQL: Be wary of straight lines in performance graphs

[Edwin Desouza]

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