kamaltin Posted December 15, 2010 Share Posted December 15, 2010 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 More sharing options...
VNguyen Posted December 15, 2010 Share Posted December 15, 2010 Hi,I think you should disable (uninstall) stats modules. It will reduce your bandwidth as well as connection to your DB.Viet Link to comment Share on other sites More sharing options...
kamaltin Posted December 15, 2010 Author Share Posted December 15, 2010 thanks. there is one problem is still remain. Hoster shutdown my shop)). I can't reach my Back Office.Can anyone advice how to disable stats modules using PHP Myadmin or probably editing any config files? Is it possible? Link to comment Share on other sites More sharing options...
VNguyen Posted December 15, 2010 Share Posted December 15, 2010 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now