Database errors

Rick Denney · Post by **Rick Denney** » Wed Dec 20, 2006 4:59 pm

Sean, I'm getting slow response and today had a batch of database errors. The last time that happened, you mentioned that some software genius needed to be applied, so maybe your genius is needed again.

Rick "respectfully submitted" Denney

WoodSheddin · Post by **WoodSheddin** » Wed Dec 20, 2006 10:07 pm

Rick Denney wrote:Sean, I'm getting slow response and today had a batch of database errors. The last time that happened, you mentioned that some software genius needed to be applied, so maybe your genius is needed again.

Rick "respectfully submitted" Denney

The site seems to be getting hammerred more and the server has been grinding slowly. Give me a couple of days to get to it and see if there is a better solution.

WoodSheddin · Post by **WoodSheddin** » Wed Dec 20, 2006 11:05 pm

Rick, (and others),,

I made a small change which I think might help. Keep me up to date if you see the slowness happen again, and make note of the exact time.

Thanks for the help

WoodSheddin · Post by **WoodSheddin** » Thu Dec 21, 2006 1:23 am

the elephant wrote:And when you make a "small adjustment" what are we talking about? I am really lame when it comes to some of this stuff. But did you just reset a parameter or change the order of some commands or swap out a line of code? What actually causes things like these slowdowns and the MySQL error messages? Just wondering. I would like to learn more about this sort of stuff. Any good books for beginners that you can recommend?

ran optimize on tables with overhead
ran a rebuild on all the BBS related tables to hopefully address any inefficient keys and the like
most importantly, setup the robots.txt files to slow down web crawlers who were nailing the site too fast

if those do not fix the problem then i will have to bring my dbo skillz up to line and address mysql optimization or conversely consider a hardware upgrade, which would be co$tly, perhaps even doubling my operating costs

Wes Krygsman · Post by **Wes Krygsman** » Thu Dec 21, 2006 2:33 am

I was having the same problem earlier today. I had to reload like 100 times before it actually worked.

Rick Denney · Post by **Rick Denney** » Thu Dec 21, 2006 11:39 am

WoodSheddin wrote:Rick, (and others),,

I made a small change which I think might help. Keep me up to date if you see the slowness happen again, and make note of the exact time.

Thanks for the help

Sean, thanks. Already today it's much better than it has been for about a week. I'll pay close attention for awhile.

When you need to pass the hat, don't be shy.

Rick "appreciative" Denney

TubaRay · Post by **TubaRay** » Thu Dec 21, 2006 2:52 pm

I'm certainly willing to be a part of underwriting, if necessary.

WoodSheddin · Post by **WoodSheddin** » Thu Dec 21, 2006 3:18 pm

Rick Denney wrote: When you need to pass the hat, don't be shy.
Rick "appreciative" Denney

I appreciate the offers, but thanks to the TubeNet Sponsors and Google Ads there is enough revenue to cover the costs if an upgrade were necessary.

I greatly appreciate all the Sponsors who keep the forum paid for.

windshieldbug · Post by **windshieldbug** » Thu Dec 21, 2006 7:17 pm

Likewise. And thanks for doing what you do. I know that you've got things handled now, but if it ever comes to that, let me be the first to offer to auction off Doc's horns.

windshieldbug · Post by **windshieldbug** » Thu Dec 21, 2006 8:00 pm

Could'a been your bass...

Database errors

Database errors

Re: Database errors