Query History and Monitoring
Web Console allows you to monitor SQL queries running in the cluster, as well as provides historical information about queries.
Monitor Currently Running Queries
In order to monitor queries running on the cluster, click on the
Monitoring menu and select
You can specify a
minimum duration for a query execution. The screen will show only those queries that have been running for more than the specified value.
You can also cancel queries. To do that, select the queries you want to cancel and click
You can cancel a single query by clicking the
x button at the end of the corresponding row.
By default, query history and monitoring is disabled in cache configuration. To activate the feature, set a non-zero value for the history size by setting the
queryDetailMetricsSize parameter of
The same can be accomplished with the GridGain Web Console configuration wizard by typing a value in the History Size text box on the Caches screen, as shown below:
Monitor Query History
To view the query-history for all the queries executed on the cluster, click on the Monitoring menu and select Queries history. This screen provides details of a query execution’s success/failure rate, execution time and more. Web Console provides an option to view queries based on type -
TEXT - or do a text search.