Jump to content
  • entries
    227
  • comments
    4,390
  • views
    101,536

Bzp Speed


Binkmeister

271 views

Techie geeky alert.

 

I've spent some significant time over the last few days trying to get BZP to run faster. After much analysis and trolling technical forums, I may have found something. I knew that repairing and optimizing the database would help, as would regularly flushing the query cache, which I've done by hand on occasion. But it looks like you really get a bang for your buck by optimizing the entire database and not just some tables.

 

I finally got sick of sitting by the computer at 2 a.m. every month, waiting for the optimization to finish, so I wrote a PHP script to wander down through each of the 156 database tables that make up the core of BZP. Each table is optimized, repaired, and flushed. Then the entire database's query cache is reset.

 

With the exception of the "posts" and "topics" tables (which each take at least an hour, sometimes two, to optimize), I just spent 15 minutes running the script. The site, with about 400 people on right now, seems to be running very quickly. As in, much more quickly than it has in a long time.

 

If this is what it takes, I'll just make sure this script is run regularly, say every week or so. And I know I said I've fixed this before, but I'm really, really hoping this helps solve this bloody latency issue. It's the single biggest nag I've got about BZP.

 

End techie geeky alert.

 

15 Comments


Recommended Comments

bink yah knowa computer might have something seious to do with bz speed. my new comp fast. my 5 year old comp very slow. so if you have a old comp or a badn line it could be the computer not bz LOL come on the skins pleaseLOL

Link to comment

All we have to do is push the earth a little further away from the sun. :sarcastic:

 

Good luck, Bink! ^_^ Although I'll be on so little during the school year that I won't really mind the drag anyway. :P

Link to comment

Yeah, I noticed that the server was running unbelievably fast this afternoon, sounds you found the solution to our woes!

 

Great job bink. ^_^ Thanks!

Link to comment

Much thanks for doing, Bink! I'm using an older computer, which always makes BZP slower, but this evening it's been running really fast, even on large topics that usually take a while to load.

 

... Not that I really understood exactly what you did, not being a techie, but whatever it was, it worked well. :happydance:

Link to comment

:happydance:

 

Well, it seemed to work.

 

Great job on the epiphany, Bink. Now, all we need is something to fix the political problems, and the world shall be in peace.

 

And let's hope that you win a Nobel for finding a way to clean up boards without being there to clean them up, ey? -Swert

Link to comment
And let's hope that you win a Nobel for finding a way to clean up boards without being there to clean them up, ey? -Swert

But other large boards are never as slow as BZP was. :P

 

But still a fantastic accomplishment, it really is much faster, thanks a lot Bink!

 

Link to comment

And let's hope that you win a Nobel for finding a way to clean up boards without being there to clean them up, ey? -Swert

But other large boards are never as slow as BZP was. :P

Other large boards frequently have more resources than BZP... we're running it all on a single server. For another web site I'm in charge of *coughLEGOFancough*, it's also on one server, but Microsoft recommended we not put a mail server on it, that apparently needs its own hardware in the MS world. Hooray for Linux!

But still a fantastic accomplishment, it really is much faster, thanks a lot Bink!

You're welcome. Let's hope it holds.

 

Link to comment

But other large boards are never as slow as BZP was. :P

That's simply because BZPower is so AWESOME.

 

Oh, and thanks Bink, I can really notice the change! I don't get the busy page as much now on peak hours.

 

 

"And the Evil Lord Survurlode wreathed in pain as The Great Bink plunged the query cache flush hard into his cold, overloaded heart promising more crystal clear surfing for BZPers everywhere!"

 

~ :kakamanu: ~

Link to comment

We writers appreciate the work Bink. The lag and Board Messages are getting a bit stressful for those of us trying to keep our stories on a regular cycle of updates.

 

...Not that I've had a chance to lately. But that's more my own schedule.

Link to comment

... something's telling me you're on the verge of making the One Refresh Ring obsolete.

Ah see, now that is the secret way to destroy the One Refresh Ring Survurlode was talking about.

 

That, or evaporation. <.<

 

~ :kakamanu: ~

Link to comment
Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...