Please I need some little help from you guys.
I have a VPS I bought since 2018 and since then one of the most difficult thing i have been facing is high load on my SQL, but i guess that was due to my big database of 1GB size. my vps spec is 16GB RAM & 6 cores.
Recently I have sold the site and deleted the 1GB database which was causing me issues on mysql server. Ever since then I have little wp sites on the server with No much traffic, but I still have mysql hitting up to 59% sometimes. I have check to see if its long query that is taking it but nothing at all.
One day I even switch off my apeche just to make sure I see the sql server uses low cpu process but to my greatest surprise I am getting at least 5-15%
I thought since no apache is connected the sql server has to fall to 0.2 or i don't even want to see it among my list of processes when i run
Please Guru in the house is it okay to get this limit while no website is running on the server. and what are the optimization needed to stop it from reaching such percentage even with no long query running on the websites. or is there an evil spirit from the old 1gb deleted database that is still disturbing the mysql server. help me out please.