Ad Widget

**Jason** · 04-01-2013, 18:34

We used this https://www.zabbix.org/wiki/Docs/how...topartitioning

So far performance has been fine. However, we are making a bigger use of proxies...

**kayjay** · 04-01-2013, 19:40

Very interesting. We only use proxies - some 200+ in all. I suppose PerconaDB has the same partitioning problem...

**mushero** · 05-01-2013, 05:14

Karjay,

See a very good thread on this:

My SQL for a given table - this purges each item according to the retention you've set by item:

Others SQL to purge just back to a given date - much simpler and faster if you have a fixed date, like 30 days ago:

Table Partitioning