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?
- enter image description here
- enter image description here
- enter image description here
enter image description here
select * from information_schema.INNODB_BUFFER_POOL_STATS
Monitor the status of the buffer pool through a MySQL metric, and provide an alert when a certain value is reached to prevent service crashes.
user26376868 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.