Edit History

On 10/22/2019 at 3:22 PM, bnadauld said:

conne

I got the reduction in size for both tables (ps_connections & ps_guest) with the following (in myphpadmin Version: 5.6.32):

ps_connections

# 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;

ps_guest

# 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???