This is very fast to fix. I will pay anyone $15 to fix this. My database was disabled by godaddy because they said some script is causing it to overload their system. They send over.... (the info below)
It has come to our attention that your hosting account, specifically the jandhdbdatabase is causing the shared resources to be over-utilized. This, in turn, affects the usage by other customers.
============================
We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:
select id from tbl_asocialpedia_edits where asocialpedia_id=9
EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tbl_asocialpedia_edits ref asocialpedia_id asocialpedia_id 9 const 5215163 Using where; Using index
This query examines 5215163 rows, which is unacceptable in shared hosting.
============================
and when i ask them which file causing that they said
=========
We are unsure of what file is running the query. The query invoked can be the result of several scripts providing information for a query, and so cannot be single-targeted. Additionally, one script can run several different types of queries based on input, and so on. Thus, we cannot detail which file is causing the issue. The issue may stem from said files not being specific enough on the query, also.
Lastly, we cannot re-enable the database until you have provided information to us as to what may be causing the issue, and have given a plan of action to fix it. When this information has been obtained, please reply with your plan so we may reinstate the database to allow completion of the troubleshooting.
Please contact us if you have any further issues.
=================
I know this is very fast to fix if you know what you are doing. If you can fix this i will release $15 immediately just find hte file that is causing the problem and rename it or delete it thanks. Please bid $15 for this quick work.
Before you bid please answer the questions.
1. what do you think the problem is?
2. how would you go about to find out which file it is our website has 1000+ files
3. what is the best way to fix this?