MySQL Forums
Forum List  »  InnoDB

Table freeze when size exceeds innodb buffer pool size
Posted by: newbie Shai
Date: September 16, 2017 01:35AM

I have a server which I have set the following innodb_buffer_pool=21G and total ram is 32. I did not specify 80% cause its running some other services besides the db too. Suddenly I saw my main data table crossing almost 50Million rows and on phpmyadmin I saw its size it also almost 40Gb. Thus I saw my queries were taking too long almost freeze but on mysql logs I dont see any errors. What can be done in this scenario?

Options: ReplyQuote




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.