My account has been suspended for the third time today (all for the same reason). After the second suspension, I took the only offending script that I could think of (a set of multiple mysql queries that runs every page load) and changed them to a cronjob (which in all honesty it should have been in the first place). However, it seems that my site is still somehow having high resource usage.
I have unsuspended the automatic suspension, but I was wondering if anyone could tell me how I can easily find an offending script that could be causing this issue or if anyone else on Chopin is having this issue as well. Admins, you're more than welcome to help with this as I am a little stumped at this point. The scripts on my site havent changed over the last year (with the exclusion of the cronjob change) and I don't believe my site traffic has altered at all (though my bandwidth reads 0 used, which I know is incorrect).
ADDENDUM 2010-10-21 2:05AM
I did find this from going through my personal SQL error logs that I'm generating:
"2010-10-21 00:58:55 SQL ERROR #1045: Access denied for user '######'@'10.33.248.77' (using password: NO)"
It seems that at irregular intervals I'm receiving this error multiple (4-8) times in one second. The thing that intrigues me about this is that "######" is my cpanel login, which is not the sql user that is used on the site. So maybe there's a possibility that someone is attempting to brute-force the site and is causing the high resource usage?
---------- Post added at 02:14 AM ---------- Previous post was at 01:34 AM ----------
A few minutes ago marks suspension #4. This is ridiculous. The site has never been suspended in the past for high resource usage (got suspended once for forgetting to log into the forums I believe lol) and the code that is on this site hasn't changed in a year. Any and all help would be greatly appreciated.
I have unsuspended the automatic suspension, but I was wondering if anyone could tell me how I can easily find an offending script that could be causing this issue or if anyone else on Chopin is having this issue as well. Admins, you're more than welcome to help with this as I am a little stumped at this point. The scripts on my site havent changed over the last year (with the exclusion of the cronjob change) and I don't believe my site traffic has altered at all (though my bandwidth reads 0 used, which I know is incorrect).
ADDENDUM 2010-10-21 2:05AM
I did find this from going through my personal SQL error logs that I'm generating:
"2010-10-21 00:58:55 SQL ERROR #1045: Access denied for user '######'@'10.33.248.77' (using password: NO)"
It seems that at irregular intervals I'm receiving this error multiple (4-8) times in one second. The thing that intrigues me about this is that "######" is my cpanel login, which is not the sql user that is used on the site. So maybe there's a possibility that someone is attempting to brute-force the site and is causing the high resource usage?
---------- Post added at 02:14 AM ---------- Previous post was at 01:34 AM ----------
A few minutes ago marks suspension #4. This is ridiculous. The site has never been suspended in the past for high resource usage (got suspended once for forgetting to log into the forums I believe lol) and the code that is on this site hasn't changed in a year. Any and all help would be greatly appreciated.
Last edited: