MySQL Forums
Forum List  »  InnoDB

innodb_buffer_pool
Posted by: 小强 小
Date: July 08, 2024 04:13AM

Storage pool size parameter: innodb_buffer_pool
1. Understanding the size of the storage pool: When accessing a large amount of data, the time for large amounts of data is not directly related to the size of the storage pool.
2. When the storage pool memory is exhausted, querying data will require a large number of disk IO operations;
3. Causes the database server CPU and IO to become full, eventually causing the service to crash;

question. Is there a MYSQL data indicator that can monitor that the storage pool size is about to be used up, and subsequent disk scans will be performed, requiring memory expansion operations?

Options: ReplyQuote


Subject
Views
Written By
Posted
innodb_buffer_pool
226
July 08, 2024 04:13AM


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.