On 10/22/2019 at 3:22 PM, bnadauld said:
I got the reduction in size for both tables (ps_connections & ps_guest) with the following (in myphpadmin Version: 5.6.32):
# Delete old connection data (only used for stats) # change 2018-01-01 00:00:00 according to you needs # myphpadmin uses American dates (Year-Month-Day) DELETE c, cs FROM ps_connections c LEFT JOIN ps_connections cs ON (c.id_connections = cs.id_connections) WHERE c.date_add < '2019-06-01 00:00:00'; OPTIMIZE TABLE ps_connections;
# Delete all guest without entry in ps_customer table DELETE g FROM ps_guest g LEFT JOIN ps_customer c ON (g.id_customer = c.id_customer) WHERE c.id_customer IS NULL; OPTIMIZE TABLE ps_guest;
Maybe this will help someone???