Tables database mysql 5.7 tc_positions without space

hrafael_salomon5 years ago

Greetings congratulations for excellent platform I have problems with table mysql tc_positions collapse for being very full 7.5 gb some idea of ​​how to delete table data thanks

Slawek5 years ago

maybe

delete from tc_positions where servertime < DATE(NOW() - INTERVAL 180 day)

In this case everything older than 180 days will be deleted

hrafael_salomon5 years ago

thanks for the prompt help I will try to do it
Greetings. Slawek