MySQL restart on the server the memory used by mySQL has increased from 1.8 GB to 9.2 GB This resulted in 97% of the Server memory being in used

Any tuning need to be set on my.cnf file.

Every week I am manually restarting server

  • 1
    Welcome to Server Fault @Anand! Have you tried any config change? Share with us any action you did to solve it. Give us more information in order to help you, e.g. some relevant part of logs, config files, computer status or the information source you are using to configure.
    – Ra_
    Jan 29 '19 at 17:14
  • Are you talking about RAM? Or disk space?
    – Rick James
    Jan 30 '19 at 2:07
  • This probably belongs in dba.stackexchange.com .
    – Rick James
    Jan 30 '19 at 2:07

If surge in data is due to your application's data being inserted, then I would suggest to move MySQL database to some other drive which has huge space.

If this isn't your application data, dig through to see what data is getting generated and stop insertion if that's not required.

MySQL system tables won't generate this huge amount of data.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.