Trying to clean old data

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

Hi @HackerOne
How many visits and actions do you have per day? In total?
Maybe you can try to delete visits day by day instead of 2 days at the same time?