Tracking search queries

mnoGoSearch supports search query tracking, which is useful to have statistics about your search engine usage, such as the most popular queries, the recent queries, the average time spent to process a search query, and so on.

Query tracking is switched off by default. To enable tracking, add the trackquery=yes parameter to the DBAddr command in your search template.

When performing search, the front-end uses the qtrack table to store the following data:

• query words

• client IP address

• the number of documents found

• time spent for search (in milliseconds)

• the current UNIX timestamp (in seconds from Epoch).

Other search parameters are stored in the qinfo table.

To make a summary of the search queries, you can execute, for example, this SQL query:

SELECT qwords,count(*),sum(found),avg(found) FROM qtrack GROUP BY qwords;