In my magento 2 website there is a table named customer_visitor which has more than 15,47,354 entries . This would have been surely making the website slow , i did not care about that untill the website completly stopped working and this error was thrown to my face .
Lock wait timeout exceeded; try restarting transaction, query was: INSERT INTO `cw_customer_visitor` (`customer_id`, `session_id`, `last_visit_at`) VALUES (?, ?, ?)
I restarted the mysql server and the error was gone , but i am afraid it would keep on increasing and i would be faced with the same problem again .
Have anyone deleted this table ? Can anyone tell me is it safe to delete this table , if someone answer , please also tell me which log tables are harmless to delete , that would have been causing problems to the system
Thanks