MySql Limitations : A possible fix

[cashique]

Alrighty here, i'm not saying this is the way to go, or that it is guaranteed to work. After tinkering with a whole bunch of setting on my site, i've finally managed to have it go for a whole 48 hours without crossing the limitations. Now, this happened over the weekend, so, i'm not really sure if that had anything to do with it, but i'll share what i did and see if the rest of you that have problems with these limits can make em go away.

I'm using nuke6.0 and phpbb2.0.4 on my website, and ever since the limitations came in, i kept maxing them out without fail two to three times everyday. Sometimes it woudn't even reset after an hour and i'll have to go change the user (yes, i manually change the user to make sure i have minimal downtime) and so on. Now, what i did lately was change the mysql host to my own server, ie comet.powweb.com. While localhost and also my own domain name works (as in it does find the database on the server), i noticed that using them always gets my users over the limit. I'm really not sure about this, maybe the admins can shed some light on it. Is it true that if we use "localhost" our queries are treated on a more global scale of sorts? Or is it that you guys have fixed something and everything is fine now?

Anyways, my site has been up for 48 hours now without me crossing the limitations. As you admins might already know, comet has had problems with sql just a few weeks back, and when that got fixed, we got hit with the limitation problems. I just hope its all in the past now.

[KimmiKat]

cashique,

I changed the deal on my mboard to "localhost" and it seemed to solve most of the problems. A co-worker who's an IT mentioned to me that using localhost takes a different path to MySQL and doesn't trip the max grant on the MySQL server so easy unless the proggy getting used gets hit by 300 people at once.

[BAD-ASS-CJ]

Now, what i did lately was change the mysql host to my own server, ie comet.powweb.com. While localhost and also my own domain name works (as in it does find the database on the server),
Do you think that you could explain, what you mean. I have no idea how to do what you said, or if i need to really.
I dont know much about MySQL or how to make changes to it.

[omni_potent]

yeah changing the username will get you working again, but localhost shouldn't make any difference. My website had been setup to connect to localhost since the great name change of the moon.powweb.com server that left my users in the dark for a day or two.

The real fix must come from powweb themselves, my site averages less than 22000 queries per hour and the limit is 36000 yet I am still getting locked out? And why dosn't the server reset? My site went down for three days! And all my calls to techsupport (long distance $$$) didn't do anything but give the impression that the tech support people don't really know wtf they are talking about.

[riceboyler]

I think it's time for the Powweb admins to admit that perhaps something is going wrong with the limitations and temporarily disable them, until they can figure out exactly what's going wrong. I don't think that we users (aka customers) are asking for too much here. We're merely trying to take advantage of the service that we PAID for, and are being prevented from doing so. I've already begun the process of switching hosts, but I'd really like to be able to back up my database, and I can't do that until they fix the stuff.

[Deskdirect]

I've always used "localhost" and I hit the wall today while working on my new (not on line yet) shop. I am concerned as to what is going to happen once I start promoting the shop!

I created a new user and the site came back up. But am I suppose to watch the shop 24-7 to make sure its up and running? Something isn't right and should be fixed/changed/altered/disabled!

[Starr]

There is nothing stopping you from doing a dump of your database.