Serious Issues with VB 3

[TheMayhem]

I have a board that has 40,000 members now and we tried VB 3 Beta out and although it is a fantastic script. Since Sunday we have been experiancing a considerable amount of server problems that are apparently caused by VB 3. I emailed my host and he replied with this message.

I found mysqld processes that were zombied which leads me to
believe, that you have scripts opening connections to SQL and not
closing them.

I only use one thing for PHP and Mysql and that's VB 3. Therefor I am wondering if this indeed could be vb 3 related on the way it was coded. And also what are some suggesitons for drastically improving the speed and reducing server load on VB 3?

[Steve Machol]

I don't think this will affect the speed, but for server load try setting persistant connections off:

// ****** PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off.
// 0 = Off; 1 = On
$usepconnect = 0;

[TheMayhem]

I don't think this will affect the speed, but for server load try setting persistant connections off:

// ****** PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off.
// 0 = Off; 1 = On
$usepconnect = 0;

What file do I edit Steve to do that?

[TheMayhem]

That was already set to OFF before Steve.

[Steve Machol]

It's config.php and if it's already off then I have no other ideas. I don't understand your host's comment about 'zombie' processes. Turning off persistent connections should close these connections.

[TheMayhem]

See if Scott can take a look at this thread and if he has any suggestions. He's always really good with server/speed type issues.

[okrogius]

It's config.php and if it's already off then I have no other ideas. I don't understand your host's comment about 'zombie' processes. Turning off persistent connections should close these connections.

Explanation of zombie processes (see processes section):
http://www.sitepoint.com/article/817/2

[bdbourn]

This is regardless of the fact that

1) The vB team are awesome coders and are really good about following standard procedures like unserring vars and closing connections

2) 99% of the scripts out there DON'T do that good a job doing that, if any

3) PHP/MySQL does a great job cleaning up after itself even if you are lazy. Open as many mysql connections as you like in a PHP script and it still won't zombie the mysqld daemon processes.

Explanation of zombie processes (see processes section):
http://www.sitepoint.com/article/817/2

[Freddie Bingham]

If your server ran vB2 adequately than it will run vB3. Maybe you have turned every option available to you on? Following are some options that can be enabled/disabled to improve performance. Try them out.

Try Disabling:
Similiar Threads
Thread Preview (Length of Thread Preview)
Check Thread Rating
Check Thread Subscription
Highlight Threads in which User Has Posted
Show Users Browsing Threads
Show Users Browsing Forums
Threaded Mode
Update Thread Views Immediately
Update Attachment Views Immediately

Enable:
Cached Posts Lifespan

[TheMayhem]

Most of those options were already disabled. However I don't believe I have Cached Posts enabled.

[TheMayhem]

I did everything suggested and it's improved my forum loading speed slightly. However the admin cp is still really lagging and the forums are no where near as fast as they were on VB 2. Anymore suggestions?

[Freddie Bingham]

If the admincp lags at startup, do you have the quick stats enabled? Turn them off if you do.

[TheMayhem]

I have removed the stats from the admin cp.

My problem is the admin cp does lag a lot. And on my forums now its loading for only me and all other users are getting a "Server too Busy" error. Yet when I check my server speed on forums or main site its extremely fast. This is becoming a major problem and I need help on how to stop it.

[Steve Machol]

Nothing from me. Freddie and the others are better qualified to understand the server speed issues.

[TheMayhem]

The server is too busy at the moment. Please try again later.

That's the error I'm getting. The forums load super fast, my site is loading super fast yet I get that error. It's weird cause the header and everything works and it just shows that inside a table.