Ram and buffer_pool_size question
Posted by: Susan Tang
Date: July 20, 2022 04:34AM

Hello. I am new to Mysql and tasked to look into a Mysql database server. It is a dedicated database server with total 8 GB of ram. The buffer_pool_size is 6 GB. There are two databases resided in the server. One database is about 60GB and the other is about 40GB. I noticed that some of queries run extremally slow. Some queries run slow at the first time, but they run faster at the second time. After awhile, the pattern repeats again. I think I need to increase the buffer_pool_size, but the databases keep growing big how many GB of ram I need to add? I hope someone can shed light on this. Thank you in advance.

Options: ReplyQuote


Subject
Written By
Posted
Ram and buffer_pool_size question
July 20, 2022 04:34AM


Sorry, you can't reply to this topic. It has been closed.

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.