Re: Rescue
Posted by: Rick James
Date: November 12, 2016 04:51PM

The values seem reasonable.

How much RAM is it using? Is it more than 60G? Are other apps grabbing lots of RAM? If so, you might need to lower the buffer_pool.

48G for the buffer_pool is reasonable; max_connections=500 is the next that might take space, but only when multiplied by some other size.

This should not be commented out; some small space is needed:
#key_buffer_size = 16777216

If you could provide these, I might discover something else:

SHOW VARIABLES; -- this goes beyond my.cnf

Options: ReplyQuote

Written By
November 09, 2016 11:06PM
Re: Rescue
November 12, 2016 04:51PM

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.