nicola82 Posted December 3, 2014 Share Posted December 3, 2014 I see that in my database there are 2 tables that are growing up too much and I think that are slowing down my website. PS_connections 9mb PS_connections_source 9mb what are they about? I mean, can I empty them in mysql db without any issue? PS 1.6.0.8 thank you. Link to comment Share on other sites More sharing options...
tuk66 Posted December 3, 2014 Share Posted December 3, 2014 9M is not too much. These tables store data about visitors. Link to comment Share on other sites More sharing options...
nicola82 Posted December 3, 2014 Author Share Posted December 3, 2014 But they store information that are also stored by google analytics, so I think I do not need them. Should I disable some modules in order to get rid of that (double) info? Link to comment Share on other sites More sharing options...
El Patron Posted December 3, 2014 Share Posted December 3, 2014 what I found about those tables is that once they get to large, then cart can stop working, this happened to me. From on IP (home) and for six bloody months I could not keep product in the cart. From any other IP it worked fine. Then one day I was exporting my db and because these tables so large, I emptied them. I could then use cart from home, and slept better. Note: always export db (back up) before making manual changes. These three(3) tables can be emptied. http://screencast.com/t/KLTaiBbYA 1 Link to comment Share on other sites More sharing options...
tuk66 Posted December 3, 2014 Share Posted December 3, 2014 All statistics are managed by several "Analytics and Stats" modules. Shop analytics is more detailed and related to your products, orders and customers. Link to comment Share on other sites More sharing options...
nicola82 Posted December 3, 2014 Author Share Posted December 3, 2014 (edited) I'll try to empity these two: PS_connections PS_connections_source the other one is not so large in my db. I'd like to disable some modules since I have 27 active modules in the Analytics and Stats section. They seem too much to me. then I want to try google page speed to see the difference, if any. Edited December 3, 2014 by nicola82 (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted December 3, 2014 Share Posted December 3, 2014 did I say just empty two(2)? they are related so empty three(3) as I suggested. thanks Link to comment Share on other sites More sharing options...
nicola82 Posted December 3, 2014 Author Share Posted December 3, 2014 ok... what about the modules? which one do I have to disable in order to not get that tables full again in few days? Link to comment Share on other sites More sharing options...
El Patron Posted December 3, 2014 Share Posted December 3, 2014 they are not 'full'... Link to comment Share on other sites More sharing options...
nicola82 Posted December 3, 2014 Author Share Posted December 3, 2014 You are right it is not full, just 86942 rows in 1 month of useless data that I already have from analytics. Link to comment Share on other sites More sharing options...
El Patron Posted December 4, 2014 Share Posted December 4, 2014 You are right it is not full, just 86942 rows in 1 month of useless data that I already have from analytics. yes I do not disagree, I would try to find an automatic way to clear them on occasion. mysql trigger, something on hosting side..there is no native feature that will do it...I asked nemo1 if his cache module did ps_connections...he said no...I would be reluctant to use 'cleaner module' as they typically cause more problems that they are worth, ,but if you find one make sure top notch developer..else all bets are off. 1 Link to comment Share on other sites More sharing options...
nicola82 Posted December 4, 2014 Author Share Posted December 4, 2014 As automatic way I've found this solution but I have some trouble to make that module work (see last message in the thread). 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