Using partitioning in database schema

[Danila]

Dear developers, don't you think that it is a time to start using partitionings in Mysql & Postgresql database schemas?

I have 50000 items, (10 sec snmp delay), and zabbix generates about 11 GBytes of data in database and database adds about 7 Gbytes of index per 24 hours!

To backup and delete data from history_uint and trends_uint I have to use partitioning (don't tell me about housekeeper, it's useless with large databases) on these tables.

I think, that using partitions "by default" in database schemas would be very much useful for people, who have to operate with large databases.

Thnx!

[Alexei]

Dear developers, don't you think that's it is a time to start using partitionings in Mysql & Postgresql database schemas?

Feel free to use it, we already strongly recommend use of table partitions for large MySQL/Oracle/PostgreSQL databases.

[xsbr]

А как это сделать?

sersad, try this:

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

[sersad]

sersad, try this:
http://zabbixzone.com/zabbix/partitioning-tables/

Thanks! My database is postgres, this manual for mysql

[sire]

See this thread: http://www.zabbix.com/forum/showthread.php?t=14208
And this article: http://www.zabbix.com/wiki/howto/db/postgres/partition