I have been using Percona server with TokuDB engine for 2 years. Now I have a one problem. I have used TokuDB row format LZMA by COMPRESSED option on LOGSERVER. This table 200M rows and now our disk 91%. So I need to descrease disk size. Then I have deleted 100M row. But not disk descrease and table open select is very slowed.
Why our table very slow? / select * from LOGTABLE limit 0,10 / this query almost 10 min executed.
I used this delete query. / delete from LOGTABLE where ID < 100M /. ID is Primary Key and Auto Increment field.
What can I do?
Please assist me on this issue.