A couple of days ago, my trends, items and history tables suddenly experienced a high volume of inserts to the point that it filled up the disk space - not only the individual innodb tables. Anyway I would like to somehow get a count of trend, item, and history records associated with a specific host. Any help in creating a mysql query for this would be greatly appreciated. I am running zabbix 1.1beta7 (yeah I know - its old, but has been extremely reliable)