Hey gang,

I'm kind of you new system administrator for now helping Kyle with some server problems. I don't have a lot of detail about how the site was before, but made some basic changes today that should help a ton.

I need to ask you guys though:

Have you noticed a difference in the response/speed of the site?

 

Yea! The site runs much much faster now. Thanks a lot for your help silvr.

 

Thanks,

I've got some more work to do as well I know the attachments are messed up right now and I'm working to see if I can get those fixed. The bulk of the problem is that there are over 50,000 attachments on the site!!

 

What's up with the "server is busy" messages. Is that a temporary thing?

 

Shouldnt happen now.

There was a load limit set to 200 on vbulletin.
Just turned it off..

 

Yes,

Unfortunately all the attachments are calculated by size and order when you go into the control panel, with 55,000 images it locks the attachment table which then backlogs the db causing massive lag on the server.

I'm working on that now, but trying not to bomb the site during peak hours

 

Hey man,
The site has been faster today than I've seen it in a looooooooonng time. The "server too busy" messages are quite tolerable in comparison to the SQL message of death that we got for so long. Nice job.

Curious, are attachments stored as objects in the DB (Globs), or are they stored as files in a filesystem somewhere? I'd imagine 50 thousand files in the FS could really be a problem....

 

Yes,

Unfortunately they are references in the DB that then call out the filesystem to check filesize, permissions, etc.. it's QUITE expensive..

Not sure how I can address it quickly...

I"m not

 

Whoops forgot to turn load limit off.

Thanks Kyle

Victor

 

I don't want to be the AUFH (Annoying User From Hell), as I'm sure you're doing anything you can, but I ran across this and though it might help. If not, please discard. I don't know what version of vBulletin is in use....

 

Well the this forum program is still in version 2.2.8
We may need that when we upgrade to 3.0+

 

Cool. I noticed in 3.0.2 that there are some improvements in the way attachments.php does queries. Good luck guys. Thanks for working on this. The whole community is VERY grateful!

 

I think its been well overdue for some improvements and now they are starting to happen!!

 

No problem,

Just hang tight gang, we'll have some upgrade going soon this week, but don't expect them to go without some kind of hitch. The site has been without maintenance in a while...

 

glad to have u help out! board is def working a lot better than previous week.

btw..where in da burgh are u? im in the oakland area, and southhills

 

Cranberry Township area

 

how did u hook up with vic?

 

We didn't, I helped convince Takao to let Kyle on and help. Kyle brought along silvrhand (John).

 

what are the specs of the server you guys are using?

 

yes most definately! the site is running much quicker... i can tell from my first time logging on that it is a bit mroe speedy in response.. thanks guys

really appreciate the work you're putting in...