How to maintain apigee analytics

Ramchanderch
Participant II

While troubleshooting heap size issue on qpidd server we ran into multiple options to resolve the current situation.

As per the flow MsgProcessor --> QpidServer (Qpidd)--> PostgresDb (Ingress)

Questions which came up during this analysis:

1. Qpid heap memory exhausted: Is it due to the fact that Queue read is at lower pace than queue write? What are the benefits / best practice to control the frequency of queue read/flush?

2. Qpid Depth check: Is it good practice increase the memory or to reduce queue depth?

3. How does the properties ingestboot-service.properties and qpidboot-service.properties help in tuning the queue depth or configure the interval to move data from qpid queue to postres db?

4. How can we modify qpid queue holding capacity?

5. How can we directly measure the size of PostgresDB apart from linux file size measure?

Can anyone please throw some light on this topic?

0 1 467
1 REPLY 1

1) Did you encounter an OOM error? I haven't run into this in my experience, but there aren't any ways to control the queue handling behavior as far as I know.

2) Not unless you are encountering runtime errors.

3) I don't believe these are used for that purpose.

4) The qpid-config utility ships with qpidd and can be used for this.

5) The PostgreSQL wiki has some information about this at https://wiki.postgresql.org/wiki/Disk_Usage.