Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

Querying the Number of SQL Statement Execution Times in the Secondary Engine

To check the success rate of queries in the secondary engine, check the status variables kovae_enter_times, kovae_execution_times, and kovae_execution_succeed_times.

The status variables related to the number of SQL statement execution times in the secondary engine are as follows. For details, see Setting and Querying KOVAE Parameters and Querying Status Variables.

  • kovae_enter_times
  • kovae_execution_times
  • kovae_execution_succeed_times

If an SQL statement fails to be filtered by the allowlist, the value of kovae_enter_times is greater than that of kovae_execution_times.

When an SQL statement fails to be executed in KOVAE, the value of kovae_execution_times is greater than that of KOVAE_execution_succeed_times.

Procedure

  1. Log in to the MySQL service through the MySQL client.
  2. Check the value of a status variable.
    show status like "%Status_variable%";
Parent topic: Feature Usage