Using SHOW STATUS to check if a feature is being used

The SHOW STATUS command shows information about the server. This includes things such as the number of bytes of data received and sent by the server, the number of connections served, the number of rows read, and so on. The command can also be used to check whether a feature has been enabled or is being used.

How to do it...

1. Launch the mysql command-line client and connect to our MariaDB database server.

2. Uninstall the Cassandra storage engine with:

   UNINSTALL SONAME 'ha_cassandra.so';
   

3. MariaDB will either respond with a Query OK message (if the Cassandra storage engine was installed and has now been uninstalled) or it will give the SONAME ha_cassandra.so does not exist error (if the Cassandra storage engine was not installed). Either of the messages is ok.

4. Issue the following SHOW STATUS command to see if the Cassandra storage engine is installed. The result will be an Empty set, which means that it is not installed:

   SHOW STATUS LIKE 'Cassandra...