I got this e-mail from the admin of the webpub server I have my XOOPS site off of:

we noticed that XOOPS uses persistent connections, and doesn't do a great job of closing them. We had an instance today where your app had all of the MySQL connections and other people's web sites went down because of it. Could you please make this change to your code:

this line: define('XOOPS_DB_PCONNECT', 1); needs to be changed to:
define('XOOPS_DB_PCONNECT', 0);
in main.php


Is this a bug? I'm not up on the XOOPS core code, but I switched it back to 0 from 1. Maybe it might have been me reloading and logging in/out so many times that caused all the connections to be used up. But regardless, I don't think I had so many sessions open. Plus, it was only me on the site, it's closed to everyone else so far. Any devs know what's up?

I'm not a Dev, but if you are using a shared hosting service, then I'd recommend that you don't use persistent connections as it consumes more resources. When you run the install script for Xoops, you are asked wether you want to use a persistent connection or not, and this sets the option in the mainfile.php