Verifying KOVAE

Procedure

1. Log in to the MySQL service through the MySQL client.
2. Run the following statement on the MySQL client to set the connection character set:

   set character_set_connection=utf8mb4;

   If the following information is displayed, the operation is successful:

    Query OK, 0 rows affected (0.00 sec)

   Check whether the connection character set is configured successfully:

   show variables like "%character_set_connection%";

   The connection character set is successfully configured. The expected result is as follows:

   +--------------------------+---------+
   | Variable_name            | Value   |
   +--------------------------+---------+
   | character_set_connection | utf8mb4 |
   +--------------------------+---------+
   1 row in set (0.00 sec)

3. After setting the secondary engine of the target table to KOVAE, run the following command to load the table. t1 indicates the name of the target table. Change it based on actual requirements.

   ALTER TABLE t1 SECONDARY_LOAD;

   If the following information is displayed, the operation is successful:

    Query OK, 0 rows affected (0.00 sec)

4. Set secondary_engine_cost_threshold to 0 to ensure that SQL statements can access the secondary engine:

   set secondary_engine_cost_threshold=0;

   If the following information is displayed, the operation is successful:

    Query OK, 0 rows affected (0.00 sec)

   1. Check the statistics of the current KOVAE status variable:

      show status like '%kovae%';

      The expected result is as follows:

      +-------------------------------+-------+
      | Variable_name                 | Value |
      +-------------------------------+-------+
      | kovae_enter_times             | 0     |
      | kovae_execution_times         | 0     |
      | kovae_execution_succeed_times | 0     |
      +-------------------------------+-------+
      3 rows in set (0.00 sec)

   2. Query all data in the t1 table:

      select * from t1;

      The expected result is as follows:

      +------+------+
      | a    | b    |
      +------+------+
      |    1 |    2 |
      |    2 |    3 |
      +------+------+
      2 rows in set (0.01 sec)

   3. Run the following command to check the updated statistics of the KOVAE status variable:

      show status like '%kovae%';

      It can be seen that the value of kovae_execution_succeed_times is updated, that is, the SQL statements have accessed KOVAE and are successfully executed in KOVAE.

      +-------------------------------+-------+
      | Variable_name                 | Value |
      +-------------------------------+-------+
      | kovae_enter_times             | 1     |
      | kovae_execution_times         | 1     |
      | kovae_execution_succeed_times | 1     |
      +-------------------------------+-------+
      3 rows in set (0.00 sec)