PDA

View Full Version : Lots of MySQL Errors


droid101
10-14-2008, 10:34 PM
Hey guys, I'm getting a lot of MySQL error emails from database hangups.

I've gathered from vBulletin support and my host's support that the issue is because many of the queries are taking too long and timing out.

What can I do to reduce queries? General tips, or checking my site for more specific help would be nice. :)

Either way, thanks!

www.constantcognizance.com

noppid
10-14-2008, 10:41 PM
You probably have a modification that is table walking a big database. But that's a guess.

Turn off the modifications system and see what happens. Or, ask your host what queries are in the mysql slow queries log causing the bottleneck.

Have you posted the specific error? The vBulletin folks are pretty smart.

droid101
10-15-2008, 06:48 PM
Have you posted the specific error? The vBulletin folks are pretty smart.
I did and they mostly said it's the host's problem. The host said that the queries are too long and timing out. So back to the drawing board.