Uninstalling KOVAE

Perform the following steps only when you no longer need KOVAE. Before uninstalling KOVAE, change all the secondary engine tables of KOVAE to the UNLOAD state. This section uses the test table t1 as an example.

For details about the configuration and operation standards of MySQL plugins, see https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html.

Procedure

Log in to the MySQL service through the MySQL client.
Unload all tables whose secondary engine is KOVAE. t1 indicates the name of the target table. Change it based on actual requirements.
If multiple tables need to be unloaded, run the SQL statements to unload the target tables one by one.
```
ALTER TABLE t1 SECONDARY_UNLOAD;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.00 sec)
```
Change the secondary engine of the tables from KOVAE to null. t1 indicates the name of the target table. Change it based on actual requirements.
```
ALTER TABLE t1 SECONDARY_ENGINE = null;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0
```
Run the following statement to uninstall KOVAE:
```
uninstall plugin kovae;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.32 sec)
```

Parent topic: KOVAE Deployment