I recieved the below msg from my website provider stating that my database ‘ufhl’ is consuming excessive resources.
My database hasnt changed since i started my service with them 2+ yrs ago except that more info is added to the database as we play new games,seasons, etc..
I am looking at getting this fixed so my acct doesnt get suspended
thanks
Mike
Here is the msg
Dear Mike,
We regret to say that database ‘ufhl’ is currently consuming excessive resources on our servers which causes our server to degrade its performance affecting all other customers database driven sites that are hosted on this server. The database/tables/queries statistical information’s are provided below:
Database Name: ufhl
AVG Queries / logged / killed
42429/ 0/ 0
These larger queries are caused probably by the plugins installed thereby causing load to the server. We suggest you to disable some of the unwanted plugins/themes. The other way is to identify the top hitters and either optimize or replace them.
If the plugins/themes are not causing any issue, you can just look for any spam contents existed in the database and clear them up.
Apart from this, you can go for identifying the top hitters accessing the web pages. Stats tool is a best option to find the top hitters as well as the IP of the particular location. Depending upon the Bandwidth accessed, top hits and IP you need to take specific actions on them to optimize the database queries.
Sincerely,
The iPage Team
