After deleted a bunch of hosts which were monitored at fast pace for a few years. it was expecting my 13GB Mysql DB to at least drop to less than 7GB, but it appears after the house keeper has run that the DB is the same size as before, and the history and trends table still have the same amount of records.
after some search on zabbix's forum,some people had the same issue.