How can I avoid having my account disabled?

[bdunning]

Twice now, PW has disabled my MySQL without notice for 24 hours for exceeding resources. (Debating whether this is the best level of service they can provide is another subject for another time.)

I want to avoid having this happen again. Is there anything I can do to gauge the level of resources that my queries are using? I called PW support and they said there is no way they know of. I'm hoping that someone here on the forums may know of a way that I can see the problems coming and address them before having all my clients' web sites shut down again.

Thanks in advance for any assistance.

[Caligatio]

Check out my thread, http://forum.powweb.com/showthread.php?t=53406

The query caching feature is key.

[mitchind]

Twice now, PW has disabled my MySQL without notice for 24 hours for exceeding resources.
What resources - bandwidth or MySQL query-related resources?
(Debating whether this is the best level of service they can provide is another subject for another time.)
There's no debate from all the other affected Powweb customers. We're the ones who complain when our sites are slowand our database servers are popping up errors.
I want to avoid having this happen again. Is there anything I can do to gauge the level of resources that my queries are using? I called PW support and they said there is no way they know of. I'm hoping that someone here on the forums may know of a way that I can see the problems coming and address them before having all my clients' web sites shut down again.That depends on what your site is doing and why it's getting overloaded - is it from big files being downloaded, heavy graphics or poorly constructed CMS software?

[Edit]
Noticed it was MySQL problem - so most likely - too many queries per use or too many connections per database. The first problem can be temporarily fixed with the 3 user login patch - the second one might be caused by poorly written CMS or forum software?

[RTH10260]

Twice now, PW has disabled my MySQL without notice for 24 hours for exceeding resources. (Debating whether this is the best level of service they can provide is another subject for another time.)

I want to avoid having this happen again. Is there anything I can do to gauge the level of resources that my queries are using? I called PW support and they said there is no way they know of. I'm hoping that someone here on the forums may know of a way that I can see the problems coming and address them before having all my clients' web sites shut down again.What resources have been exeeded ?

I read the first time here that an account gets suspended for exeeding resources on MySql. The usual problems happen with connects (7200 per db-username per hour) and queries (72000 per db-username per hour) and both on a 60 minutes rolling scheme.

Have you been using permanent connections, mysql_pconnect() rather than mysql_connect() ? These block up server resources in a shared environment. Have you been running queries that return monster result sets and bog the servers memory resources down ? What can you see in the error log of your website ? And least but not last - what application are you using ?