Please I want some little assist from you guys.
I’ve a VPS I purchased since 2018 and since then probably the most tough factor i’ve been going through is excessive load on my SQL, however i assume that was on account of my large database of 1GB dimension.
my vps spec is 16GB RAM & 6 cores.
Lately I’ve offered the location and deleted the 1GB database which was inflicting me points on mysql server. Ever since then I’ve little wp websites on the server with No a lot visitors, however I nonetheless have mysql hitting as much as 59% typically. I’ve examine to see if its lengthy question that’s taking it however nothing in any respect.
Sooner or later I even swap off my apeche simply to verify I see the sql server makes use of low cpu course of however to my biggest shock I get not less than 5-15%
I assumed since no apache is related the sql server has to fall to 0.2 or i do not even need to see it amongst my record of processes when i run
Please Guru in the home is it okay to get this restrict whereas no web site is operating on the server. and what are the optimization wanted to cease it from reaching such share even with no lengthy question operating on the web sites. or is there an evil spirit from the previous 1gb deleted database that’s nonetheless disturbing the mysql server. assist me out please.