Jump to content

Hoster said "Too many conections to DB"


Recommended Posts

HI,
my hoster inform about large quantity of connections to my database. Here is a part of the log:

| 486675 | u1016378 | 10.8.204.79:39485 | db1016378 | Query | 15538 | Locked | DELETE FROM `ps_connections_page` WHERE id_connections IN ( SELECT `id_connections` FROM |

| 487971 | u1016378 | 10.8.204.79:38674 | db1016378 | Query | 15230 | Locked | DELETE FROM `ps_connections_page`WHERE id_connections IN (SELECT `id_connections`FROM |

He notice that service stopped until problem will not be solved. Would you please advice what can I do to decrease number of connections? PS version is 1.3.1.1.

Regards,
Kamal.

Link to comment
Share on other sites

Hi,

If you can access phpMyAdmin, then you can edit this table: ps_module and set "active" to 0 for corresponding modules.

I guess you are using shared VPS server, so you can not set bigger value for maximum connection to your database, and I also guess hoster block some table in your database. The way they block these tables is rename physical files of your tables in your databse, and no way to reset database server till they unblock them.

Viet

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...