MySQL Forums
Forum List  »  InnoDB

mysql buffer pool how monitor
Posted by: c h
Date: July 07, 2024 07:06AM

The memory size of my server is 128GB with a 4-core processor, and I have configured the MySQL buffer pool to 12GB. Every time when concurrent requests start, I notice that the MySQL service becomes slow, with FREE_BUFFERS approaching 0, server I/O reaching 100%, and CPU usage spiking to 400%. Despite having reasonable indexes for queries. How should I adjust the MySQL buffer pool size to avoid the aforementioned issues, or which MySQL metrics should I monitor to set alerts for the server to prevent crashes?

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql buffer pool how monitor
198
c h
July 07, 2024 07:06AM


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.