View Single Post
slmclarengt
Veteran Member
Join Date: Jul 2004
Location: The Cookie Jar... or Pullman, WA (Washington State University)
Old 12-05-2007 , 14:21   Re: "MySQL server has gone away" occurring
Reply With Quote #4

Quote:
Originally Posted by Geesu View Post
Yea that is what I was considering doing... but I hate that Seems like such a hack to fix some larger problem...

I'm wondering if too many queries are executed too fast? Would be interesting to see how many players on on when it happens.

Josh
Personally I think that's exactly what it is; there are probably way too many queries called within too short of a time period. Also, is there any way you could think of to speed up server changelevel time (hint: pruning feature for SQL ;-)) because I think a lot of lag issues in my server relate back to WC3FT retrieval/saving...

I asked my friend to write me an SQL script to prune my database and I am going to cron job it so it prunes my massive database.

Slmclarengt
__________________
But we don’t beat the Reaper by living longer. We beat the Reaper by living well. -Dr. Randy Pausch, R.I.P.

Come play WC3:FT on BnD Clan Server! You know you want to: Connect to WC3:FT BnD - go ahead click me!
slmclarengt is offline