How to delete older data queuing in Administration-> Queue

[aic]

Hello,

I am lost because Zabbix Oracle DB is using too much CPU.

I would like to remove the old data collected because is not possible to complete activities. There are more than 2200 items older than 10 minutes..

Thanks!

[untergeek]

I am sympathetic to your situation. Getting Oracle to handle the load we're throwing it for Zabbix was a challenge.

Something you need to understand about the Queue is that it's not real. It's called a queue, but there really isn't a list of things waiting anywhere. The queue in the Zabbix UI is querying the database and showing the numbers of items which should have been updated within a given time frame but haven't.

e.g. in pseudo-sql-code, select count(*) from items where [the next check time] < $now+(30 seconds|1 minute|5 minutes|10 minutes)

You get the idea. There is no actual queue. The numbers shown are queried in real-time when you open the page.