Use Pconnect?

[bigsoccer tech]

We have four web servers. Our sysadmin is recommending using Pconnect - we currently have it off? We wants me to ask here if we should turn it on. We are havign some db issues where our db runs out of threads/cnxns. our site is very large and he says its application dependent if its good to have on or not. wants to know what vb thinks..

so?

[Steve Machol]

Personally I would leave this turned off, otherise you may run into 'max_connections' errors. If you really want to turn this on, you do it in the config.php file:

        //      ****** MASTER DATABASE 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)
$config['MasterServer']['usepconnect'] = 1; 

[bigsoccer tech]

Steve

Not asking how but why/if? We are already running into max cnxns errors which is why we were exploring it. The only threads on thsi site debating the pro cons are 2 years old. Can someone explain why /if a large site shoudl consider it?

[Steve Machol]

As I said "personally I would leave this turned off, otherise you may run into 'max_connections' errors". I have never run into any situation where I saw a noticable benefit to having persistent connections turned on.

[Mike Sullivan]

The connection overhead of MySQL is not especially large. The connections are persistant per Apache thread only, I believe, so you'd have a lot of connections open at a time, which means more memory usage.

Personally, I'd leave them off. But it's one of those things that you should test for a day each way and see what works better.

[bigsoccer tech]

Thanks guys. Great support as always.