That's a good question. I'm not sure what is the right answer to your question. I'll do some investigation and get back to you if I find an good answer. You should email the people at Verisign as they probably could help you..
Don't know, but maybe try setting both configure.php files.
Persistent connections to false..
Yep it was already set persistent connections to fales. Also I left define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'.
So as it's '' then the sessions should be stored to the files in TMP directory not leaving open connections on the server (i think????).
So both config files are.
Define('USE_PCONNECT', 'false'); // use persisstent connections?.
Define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'.
So why am I getting open connections in the databse?.
My sites database has grown from 10mb to 50 mb in a month and ive had less than 100 orders. Is that right?.
Also, when I backup the Verisign site using tools, backup it's about 12 MB but when I back up using phpmyadmin (adding a drop table) it's about 50MB. So why the difference in filesize?.
How can I see "open connections" or what IP address is opening these connections, thanks..
Have a look in phpmy admin and see which tables are large..
Then you look and can decide if it is normal...
I guess your sessions are stored in your db. Try creating a directory for them under catalog, and change both config.php files to reflect the new directory...
How do I do this please exactly at the moment it's define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'.
So the sesions are NOT going to sql but are going to "" whereever that it.
You could make a directory called "whatever" where your catalog files are and set.
Define('STORE_SESSIONS', 'whatever'); // leave empty '' for default handler or set to 'mysql'.
And see if that helps. If it doesn't, undo the changes...