Modern Vespa

Seriously, fix the PHP errors and obvious overloading of the server that this script is running on.

Thanks in advance,
Everyone on Modernvespa.com

Ditto...I thought it was Safari acting up again.

Dave

The real crux of the issue is the load on the MySQL database, which is actually running on a different server. The web portion of the site, and even the PHP scripts, actually run very efficiently. Every time the PHP scripts have to do a database query, though (and that's many times for every page) everything slows down. If this were a static website, it would load as fast as the fastest website you've ever seen. Since we're dependent on MySQL, though, and because the webhost hasn't quite figured out how to make the separate MySQL server run efficiently, we're in purgatory.

I've been put on a list of clients that will eventually be moved to a different "special" MySQL server. So now we wait.

Of course, this morning the entire site really did go down for, what, an hour? Ack.

And there were a LOT of duplicate posts.I spent about an hour trying to seek and destroy them. There were 5 duplicates on one post.

(See,us mods don't spend ALL day sipping cocktails in the MV bar... )

Well, some of us do. We just send Ian out to do the dirty work.

I KNEW it...

Jess, MV is just too popular!
Ever think about archiving? You've got a hell of a lot of rows of data out there.

Possibly, although I'm inclined to believe that the source of the problem is the architecture of the grid system we're running on, since the webhost has acknowledged that they're having massive problems with it and I know there are other clients having similar issues. We were actually performing relatively decently before we switched from a shared server to the new architecture. The shared server suffered occasionally from the "bad neighbor" effect, where someone else on the server did something egregious and it slowed everyone else down, but those events were relatively infrequent compared to the daily issues we've been having on the new system.

Before I do anything as rash as archiving, I'm going to wait out the switch to a new MySQL server and see how it goes. If it still sucks, I may resort to archiving older posts.

Or maybe I'll just switch hosts.

So the site really was down this morning. Went to log on and couldn't. So i went and got coffee.When i got back it was up and running. For a moment i did think i was seeing things

Unfortunately, MySQL is popular, but not really up to the loads of a heavy usage site. Because it's popular (LAMP) phpBB is designed against it and leverages some of it's features making it a little tricky to run against other DB's, and even harder to migrate to them once you have data.

For my day job we altered a copy of phpBB to run against Microsoft SQL Server, and it's better, but PHP on Windows is noticeably slower than on Linux. So for another side project, I have a version of phpBB running on an Apple Xserve using PostgreSQL as the backend. It's better, but still has some performance bottlenecks.

I feel for ya' Jess. None of the commercial web hosts really support anything but MySQL on the inexpensive hosting plans, and unfortunately, migrating from phpBB and MySQL to anything else is problematic. This is why most of the high traffic boards have moved to something a little more scalable.

Personally, I building a Java based engine with a WebObjects web application targeting Xserve's for Two Wheel Junction. It's a ton of work, but from a scalability standpoint, I cannot find anything readily available that will handle the loads.

I have such respect for you techie types. Reading Dru's post it might as well have said....

wivnf gkt foms xcsme cofmv fhg dk cic wzv fjssaoc ssjc asnc ssjdiee XXdjw dinc dhwkz.

That's exactly how that stuff sounds to me.

I am just glad MV is running and is in capable hands.

+1 On that issue Seth! Beale.

Man, is it reeeaallly slow today or is it just me?

Yes it's really slow (though the urge to say it's just you is powerful )

I suspect that the MySQL DB is running out of memory and that at some point today, we will see another downtime while it crashes and rebuilds itself

They promise we'll be moved to the optimized MySQL server in the next couple of days. There's a waiting list, natch.

They did mention, almost off-handed, that they thought it was unreasonable for a phpbb forum to be straining as much as it is. In other words, they thought maybe there was something else afoot that might be causing problems, and that a forum of our size (which is not really all that large in the cosmic scheme of things) should perform much better than it currently is.

Want to put this in perspective? My host now promises me the site will be back online with 60 days.

I was told "tomorrow" then, "two more days" then "a week" then "two weeks" and now, 60 days.

What originated as an announcement about a problem with a fibre optic line that would be fixed within 12 hours has turned into a four month operation.

And they won't give out backups.

So don't moan!! You could be worse off, after all.

Today was the worst. Sometimes around noon HST i'll have some trouble but then it's 5-6pm in the east. Today at 8am my time nada. Sorry jess for the pm if i had seen your last post wouldn't have sent you one. Got on once and it took 10 min. Had to go on e-bay and spend money

Its probly just the flux capacitor...
How many gigawatts is it anyway?

Whoa, you folks in the UK have issues. If my company didn't have a fiber bundle repaired in 24 hours the feds would take our licenses away!