mykes, do you really know what you are talking about?
Brian has been running the software for ages on his own rather large forum.
Now, the things that could cause the load are any full table scans.
Are you showing the ammount of new posts / threads since last visit or anything else?
I turned the stats module OFF. As well as most of the modules, except for the news one, latest forum topics, and the show users.
If the hack requires indexes to be created, it should create them.
Or the install instructions should include info on which ones need to be created.
If people running big sites run this out of the box, it's got a huge potential to tank their whole site.
I apologize for sounding alarmist over this, but it is a huge deal when you install something like this and it takes your site off the air for 15 minutes.
I turned the stats module OFF. As well as most of the modules, except for the news one, latest forum topics, and the show users.
If the hack requires indexes to be created, it should create them.
Or the install instructions should include info on which ones need to be created.
If people running big sites run this out of the box, it's got a huge potential to tank their whole site.
I apologize for sounding alarmist over this, but it is a huge deal when you install something like this and it takes your site off the air for 15 minutes.
Like Brian told you at vBa, he also runs a rather larger forum with a stock configuration of the script.
Latest threads could result in a big problem because of a full table scan unless you are limiting it in some way.
Like Brian told you at vBa, he also runs a rather larger forum with a stock configuration of the script.
Latest threads could result in a big problem because of a full table scan unless you are limiting it in some way.
OK, so how does a stock script that doesn't limit in some way the full table scans work out of the box on a rather larger forum? The probable answer is he's been hacking on php scripts that slowed his site down so he implemented the proper indexes to speed them up. When HE runs this script out of the box, he doesn't see the problem.
BTW, I'm looking at the output of iostat 1 and not seeing a full table scan happening when I load the page, with latest threads turned on, and with all the bells and whistles.
What I do see is the CPU idle% go to ZERO on all 4 (well, 2 Xeons) CPUs when vba is the site's home page. When it's not the home page, the CPUs are 75% idle, each.
Here's a pretty nifty perl script I wrote to monitor a linux system's health. It requires Term::Screen perl module installed. You may have to make your shell window taller, or hit the 'c' key while it's running to make it display less tall.
OK I have a dual Xeon 2.4 and have been running the portal since moving from IPB to VB last year..
I have on average 200-300 memebers on the site at any time and server load has been pretty normal BUT add an extra 100 members and the serverload hits the roof and often crashes the forums out..
I remove the portal from my site the other day and lo and behold server load is down and my site is flying now with over 700 members online..
I am not dissing this product as TBH I loved it BUT I have had to compromise either getting a bigger server or removing the hack.....
The hack had to go...
This needs looking into as it is not a figment of peoples imaginations and is a real problem for people with large sites...
OK I have a dual Xeon 2.4 and have been running the portal since moving from IPB to VB last year..
I have on average 200-300 memebers on the site at any time and server load has been pretty normal BUT add an extra 100 members and the serverload hits the roof and often crashes the forums out..
I remove the portal from my site the other day and lo and behold server load is down and my site is flying now with over 700 members online..
I am not dissing this product as TBH I loved it BUT I have had to compromise either getting a bigger server or removing the hack.....
The hack had to go...
This needs looking into as it is not a figment of peoples imaginations and is a real problem for people with large sites...
H
Shack, if you have the time, contact Brian over at vBadvanced.com in a troulbe ticket and he should be able to sort some things.
We are making advancedments in optmizing the script more