Help needed History table partition / index - approach

[sarathyme]

I use Zabbix with MySQL InnoDB.

Two things

1) History table is nearly 20 GB (history.ibd). Should I partition MySQL table?
Would it be safe to do it?

(I have seen this
http://forums.mysql.com/read.php?106...2641#msg-82641
Not sure Brain has done partitioning)

2) We also have another requirement for reporting, that needs history table data.
Would like to take last days history data and send to reporting system.
I see zabbix has index on history table (itemid,clock).
Our query would be like select * from history where clock > and clock < .
Should I have to create index on (clock) as well.

Any help highly appreciated

Thanks
Vijay

[danrog]

Have you tried this?

[sarathyme]

No i have not tried it yet.
Are you planning to do the same?

[xsbr]

No i have not tried it yet.
Are you planning to do the same?

sarathyme, I created a post about partitioning:

http://zabbixzone.com/zabbix/partitioning-tables/