Is there a Cron task to clear Mysql connections_source

[gray]

Is there a Cron task to clear Mysql connections_source

I am up to 2.5GB

Seem to remember clearing the table manually. But it would be nice if there was a cron task ??

Any ideas please.

[juanrojas]

Hello
Manually view this module
Use cron to view this module

[Prestashop Addict]

Hi, according to Prestashop tables related to statistics, and unnecessary collected data we strongly recommend to uninstall following modules if you use an external analysis system like Google Analytics. Because some data will be redondant, and made the database growing with huge data!

- pagesnotfound
- statsdata
- statslive

And verify tables has been removed ps_connections, ps_guest, ps_connections_source.. if not delete them. You can also look at layered filters if you have a very large catalog, or lot of filters table ps_layered_filter_block ca be huge also. By the way if you still want to keep theses modules, you can use this module to truncate, or delete rows in table manually or with a cron task https://boutique.comonsoft.com/gb/prestashop-modules/26-database-optimization.html