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
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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.