AstRecipes » Debugging Qloaderd installation

Checking the database can be written to

Checking if data is present in the database

1. connect to the QueueMetrics database using a MySQL shell or GUI
2. issue the following query:

The result should look something like:

This report shows:
That we are using three distinct partitions: P003, P01 and rt. You will at first find only one.
For each partition, we see the Asterisk queue names involved plus the special keyword NONE
For each queue, we get an idea of how many records it generated, i.e. how big it was. As a rough estimate, consider that each call generates an average of around three records.

Checking all data is in the database

If you want a breakdown by day of the contents of the each partition, you can run the following query:

The result will look something like:

Tags:
MySQL   qloaderd   QueueMetrics