Neo4j DB - Query Caching

In this section, learn how to fasten, and setup Query Caching for your Neo4j data source.

On this Page

Go to Data source configuration in Grafana.
Under HTTP settings, enter the URL as - http://hostname:portno/PlatformService/datasource/neo4jds. Select Access as proxy.

In the URL, please input the Host & Port No., where PlatformService.war is hosted.
Select Basic Auth in HTTP Auth.
Enter Basic Auth Details (Note: Please input the admin credentials in this section).
Click Save & Test. It shall return a confirmation, "Data Source is working properly".

Go to Dashboards, select a panel to configure.
Select the configured Neo4j query caching data source.
Input the cypher query in the query editor, select the option "Cache results".
Select the type of caching, and it's value.
Save the panel, and dashboard.

There are 2 types of caching, which you can select as per your convenience.

Types of Caching -
Fixed Time: In this type of caching, the results will cached for the selected hour duration and the grafana's time selector would be disabled for the selected time duration in hours.
Variance Time: In this type of caching, the results will be cached in percentage based on the duration selected in grafana's time selector. Eg: If duration is set to Last 3 hours and the Variance Time is 5%, then results will be cached for 9 minutes (5% of 3 hours).

By default, all the query cache results will be stored at the index - http://hostname:9200/neo4j-cached-results/querycacheresult/.
If you want to change this index, please add a custom property in server-config.json.
Query Caching Index Property in server-config.json

"queryCache":
{
"esCacheIndex": "neo4j-cached-results-custom"
}

In the above property the custom index is defined as neo4j-cached-results-custom. If you add your custom index, the URL where results will be stored is - http://hostname:9200/your-set-custom-index/querycacheresults/.

In the URL, please input the Host & Port No., where Elasticsearch is hosted and running.

Top Section