mysql03.powweb.com

[Craigstrom]

I dunno whats been happening lately, but my MySQL site based on the mysql03.powweb.com site has been really acting up over the past weeks. This isnt' the first time. Ive been with this same site and same sql sever now for just over a year, and its just getting worse and worse...

I'll have times when every other page view gives a mysql error, and then I'll experience times when its every few minutes, and then everything will be fine for a few days,etc.

Its the same site ive been running for 13 months (no updates, changes, etc). and the past couple months have really been bad. To the point where my userbase is saying say la vie.

Is this something that powweb expects me to live with? Just curious as I would gladly pay anyone else triple to overcome this issue.

Thanks.

[RTH10260]

Just curious as I would gladly pay anyone else triple to overcome this issue.As you don't reveal what kind of error message you keep getting, or how your database is available or not, it is a bit difficult to guess.

What I have observed here in the forums, is that forum systems regulary hit either the connection limit or the query limit. The limits are counted over the last rolling hour. The intermittent occurance you observe is likely caused by the application just hovering below the limits. The limits are mentioned in the TOS.

The workaround is to add the full complement of three database usernames to the database, and use a random username for each connection. This spreads the load among these usernames, and each has the limits individually.

Samples for recoding can be found in several other threads.

[Croc Hunter]

I agree RTH, if it were a mysql03 problem more would be reporting it. I have a phpbb forum and have had no complaints and have seen no errors myself. Quoting your error message will help us narrow it down. And is it postNuke or some other CMS?.