msk69 Posted April 22, 2009 Share Posted April 22, 2009 i was browsing thrue the database, and found that those two tables are taking about 10mb of space in the db. Can these fields be deleted without problems?Thanks in advanced,Marco Link to comment Share on other sites More sharing options...
andrew Posted October 2, 2009 Share Posted October 2, 2009 Any ideas what they are for - I am also having an issue with the size of these 2 tables?- Andrew Link to comment Share on other sites More sharing options...
rcking Posted December 9, 2009 Share Posted December 9, 2009 Hi,i known that tb_session_adm can empty. But i am not sure with connestions_page. Is it only for stats? Link to comment Share on other sites More sharing options...
Cornel Posted December 11, 2009 Share Posted December 11, 2009 Yeah, I would like to know if we can empty them, along with the ps_pagenotfound, I have almost 1M of rows here and the databse it's really large. can we empty them? Link to comment Share on other sites More sharing options...
gk Posted July 10, 2010 Share Posted July 10, 2010 I also have the same question. These two tables are taking up 20+ MB, and causing my DB backup to fail (I'm using a shared hosting plan).Is it safe to delete the content from these tables? What are the consequences? Link to comment Share on other sites More sharing options...
rcking Posted July 10, 2010 Share Posted July 10, 2010 ok guys... I did it and it works... so don't worry.. erase it! www.rcking.eu Link to comment Share on other sites More sharing options...
rocky Posted July 11, 2010 Share Posted July 11, 2010 Yes, you can empty those tables. The only thing you'll lose is the customer's "last visited" date. You can also go to Stats > Settings and automatically clean out these tables on a weekly, monthly or yearly basis. 1 Link to comment Share on other sites More sharing options...
gk Posted July 11, 2010 Share Posted July 11, 2010 Thanks for the confirmation!When exactly does the weekly / monthly / yearly cleanup process kick in? Link to comment Share on other sites More sharing options...
rocky Posted July 11, 2010 Share Posted July 11, 2010 Every time a connection is made to your site, the cleaner deletes all connections older than 1 week, 1 month or 1 year. Link to comment Share on other sites More sharing options...
MrBaseball34 Posted July 12, 2010 Share Posted July 12, 2010 Hey, rocky, how about the page_viewed table, can it, too be emptied? And, I also noticed the search_index table is quite large, what is that for? Link to comment Share on other sites More sharing options...
rocky Posted July 12, 2010 Share Posted July 12, 2010 The page_viewed table stores which pages were viewed by which customers and what time. I suppose you could empty that table too if you aren't interested in that information.The search_index table is used for the search autocomplete. If you aren't using that feature, I suppose you could clear it as well, though I'm not sure whether it is used for regular search. Make a backup first just in case. You can change the settings and regenerate the search index on the Preferences > Search tab. Link to comment Share on other sites More sharing options...
ideegeniali Posted January 27, 2011 Share Posted January 27, 2011 Rocky: I emptied connections, connections_page and connections_source.And now they get no new entries, they remain empty. How do I fix this? Link to comment Share on other sites More sharing options...
Site Posted June 10, 2011 Share Posted June 10, 2011 ideegeniali which version of prestashop are you on ? Link to comment Share on other sites More sharing options...
ideegeniali Posted June 10, 2011 Share Posted June 10, 2011 Prestashop V1.3.2.3 Link to comment Share on other sites More sharing options...
emilianoavendano Posted June 30, 2011 Share Posted June 30, 2011 Si. Una buena practica de mantenimiento es limpiar "empty" ps_connections and ps_connections_page pueden ser borradas sin problema.Yo lo hago cada semana para evitar que la bd cresca con datos que no necesito.Saludos desde Colombia:http://www.coltiendas.com Link to comment Share on other sites More sharing options...
deepee Posted July 20, 2011 Share Posted July 20, 2011 Is it safe to empty ps_connections_source as well? Link to comment Share on other sites More sharing options...
emilianoavendano Posted July 21, 2011 Share Posted July 21, 2011 Yes, you can empty ps_connections and ps_connections_page without problem.Ihave done I it in some stores of the Coltiendas.com network! Link to comment Share on other sites More sharing options...
deepee Posted July 21, 2011 Share Posted July 21, 2011 Thanks, I just emptied the three ps_connection related tables.They were taking up nearly 100MB of disk space!All pages are loading much faster and I hope this is because of the reduction in the database size, and not just a coincidence. Link to comment Share on other sites More sharing options...
deepee Posted February 2, 2012 Share Posted February 2, 2012 Is ps_guest safe to empty? Link to comment Share on other sites More sharing options...
the.rampage.rado Posted May 18, 2013 Share Posted May 18, 2013 For me (clean 1.5.4.1) the auto clean doesn't work... What to check? My ps_connections and ps_guest tables are ~40k rows and I think they slow my site down, I would like to keep 1 week stats but no good... :| Link to comment Share on other sites More sharing options...
AnnaM Posted May 21, 2013 Share Posted May 21, 2013 And what about the "upload folder", can it be cleanes as well? thanks (prestashop 1.5) Link to comment Share on other sites More sharing options...
vekia Posted May 21, 2013 Share Posted May 21, 2013 if you don't use those files - yes. Link to comment Share on other sites More sharing options...
AnnaM Posted May 21, 2013 Share Posted May 21, 2013 I believe I don´t use them but as I don´t know why they are created ... Link to comment Share on other sites More sharing options...
BassDrive Posted June 6, 2013 Share Posted June 6, 2013 I was changed ps-connections, and my web page has error: Link to database cannot be established. Can I turn back ? Link to comment Share on other sites More sharing options...
vekia Posted June 7, 2013 Share Posted June 7, 2013 you said - that you changed it. What you change there? You mean that you clean all unecessary data? Link to comment Share on other sites More sharing options...
Pippo3000 Posted October 22, 2013 Share Posted October 22, 2013 For me (clean 1.5.4.1) the auto clean doesn't work... What to check? My ps_connections and ps_guest tables are ~40k rows and I think they slow my site down, I would like to keep 1 week stats but no good... :| Same here. Cleaning Rate set to weekly in the back office but nonetheless the two tables here were some 50mb in size. Just emptied them manually but wonder, too, why they are not cleaned automatically as defined in the BO? Link to comment Share on other sites More sharing options...
vekia Posted October 22, 2013 Share Posted October 22, 2013 hello where exactly you defined setting to empty these tables? Link to comment Share on other sites More sharing options...
Pippo3000 Posted October 22, 2013 Share Posted October 22, 2013 Stats --> Settings --> Weekly Link to comment Share on other sites More sharing options...
Gu1llaume Posted February 26, 2014 Share Posted February 26, 2014 Same problem here.. No answer ? Link to comment Share on other sites More sharing options...
fabfab Posted May 13, 2014 Share Posted May 13, 2014 Here same problem. No auto delete after a month. Database far to big. I would like to upgrade, but fails because of to big tables. Link to comment Share on other sites More sharing options...
idoityourself Posted September 25, 2014 Share Posted September 25, 2014 (edited) Im getting stuck in the update on ps_cart_product table Can that be deleted and where would I do that? Edited September 25, 2014 by idoityourself (see edit history) Link to comment Share on other sites More sharing options...
mma87 Posted March 31, 2015 Share Posted March 31, 2015 I use this sql query to clean my database TRUNCATE TABLE `ps_connections`; TRUNCATE TABLE `ps_connections_page`;TRUNCATE TABLE `ps_connections_source`;TRUNCATE TABLE `ps_page_viewed`;TRUNCATE TABLE `ps_guest`; backup the database before you do this query!! Matteo 1 Link to comment Share on other sites More sharing options...
RobbieBlokeToys Posted November 16, 2015 Share Posted November 16, 2015 Every time a connection is made to your site, the cleaner deletes all connections older than 1 week, 1 month or 1 year. So this means that it only empties the individuals info if they return, and if they allow the cookie too? It definitely doesn't delete everything on any routine pattern because I have to manually do this when things start to slow down. There really needs to be a setting somewhere in the back office when to clean up the tables automatically, with us able to select once a day, week or month etc. Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2015 Share Posted November 16, 2015 Try this module form Vekia - it is brilliant. Brought our customer page load times down from 60 secs to 2 secs https://mypresta.eu/modules/administration-tools/database-optimization.html Not automatic, but easy to use every few weeks Link to comment Share on other sites More sharing options...
ingrossoerisparmio Posted December 3, 2015 Share Posted December 3, 2015 but how disable writing in these tables? If i not use statistics, is not performing all this writing. Link to comment Share on other sites More sharing options...
El Patron Posted December 3, 2015 Share Posted December 3, 2015 (edited) but how disable writing in these tables? If i not use statistics, is not performing all this writing. you would need to search your entire native PrestaShop to determine 1) how to disable and 2) 'all' areas of native that are using this information and action them as well. or you can empty them manually, create a mysql trigger to do it, use a module solution.... Edited December 3, 2015 by El Patron (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts