My website is leaving connections open on the database

[thailandosc]

My hosting company is threatenting to kick me off because they say my oscommerce script is leaving a "log of open database connections" which is overloading their server.

 

I dont understand this at all can someone advise whats going on here. I dont get many hits maybe 20 visits a day. Someone suggested a search bot or a hacker is opening these connections.

 

My isp "fixed it" several times but being stupid they wont tell me what they did to fix it. When it gets bad it runs VERY slow or i get the "too many connections in database" error.

 

 

How can i a) close all the open connections B) stop bloody search spiders going into it and opening many connecitons if thats whats happening.

 

 

Im about to get kicked from my hosting company...

 

 

I am using oscommerce 2.2 i used 7dana.com ecommerce manager (which is a great template with loads of addons already installed)

 

Thanks

[celina2007]

I have no idea, but as you mentioned blocking spiders, try this

 

http://addons.oscommerce.com/info/6303

[Guest]

My hosting company is threatenting to kick me off because they say my oscommerce script is leaving a "log of open database connections" which is overloading their server.

 

I dont understand this at all can someone advise whats going on here. I dont get many hits maybe 20 visits a day. Someone suggested a search bot or a hacker is opening these connections.

 

My isp "fixed it" several times but being stupid they wont tell me what they did to fix it. When it gets bad it runs VERY slow or i get the "too many connections in database" error.

 

 

How can i a) close all the open connections B) stop bloody search spiders going into it and opening many connecitons if thats whats happening.

 

 

Im about to get kicked from my hosting company...

 

 

I am using oscommerce 2.2 i used 7dana.com ecommerce manager (which is a great template with loads of addons already installed)

 

Thanks

Don't know, but maybe try setting both configure.php files

persistent connections to false

[thailandosc]

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 its '' 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?

 

Thanks

[thailandosc]

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 its '' 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?

 

Thanks

 

 

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 site using tools, backup its about 12 MB but when i back up using phpmyadmin (adding a drop table) its about 50MB. So why the difference in filesize?

 

How can i see "open connections" or what IP address is opening these connections, thanks

[♥geoffreywalton]

Have a look in phpmy admin and see which tables are large.

 

Then you look and can decide if it is normal.

[Guest]

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 its '' 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?

 

Thanks

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.

[thailandosc]

Thanks

 

How do i do this please exactly at the moment its 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

 

Cheers

[Guest]

Thanks

 

How do i do this please exactly at the moment its 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

 

Cheers

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.