I am trying to clean up old data in various ways and i am not moving at all…
its a mariadb and the database is arround 100GB.
even when i try to run : ./console core:delete-logs-data --dates=2021-01-01,2021-01-02
it tages ages and finally i get this error :
General error: 1205 Lock wait timeout exceeded; try restarting transaction
I changed the innodb_lock_wait_timeout | 200
from 50 to 200 and still i am getting errors.
what is the best way to start cleaning old stuff