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
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
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.