Under 2.8.3 when trying to delete from the command line a site via:
DELETE FROM piwik_log_link_visit_action WHERE idsite = 2;
I got the error:
ERROR 1206 (HY000) at line 18: The total number of locks exceeds the lock table size
From looking at the doc at (look for the 1206 error section):
my question is what be the recommendation for what to increase innodb_buffer_pool_size to from the default?
I did try to do smaller data samples via:
DELETE FROM piwik_log_link_visit_action WHERE server_time < DATE_SUB(NOW(),INTERVAL 5 MONTH) and idsite = 2;
but to no avail, got the same error message. When I changed it to 6 months, it came back saying nothing to do, as I
expected since there is not data that old.