Using extended statistics

MariaDB includes a powerful feature for collecting extended user statistics. These statistics can be used to better understand how our server is behaving and to locate and identify the sources of our server's load.

How to do it...

1. Connect to MariaDB using the mysql command-line client with a user that has the SUPER privilege.

2. Enable statistics collection with the following command:

   SET GLOBAL userstat=1;
   

3. Run the following commands to show the statistics collected since collection was enabled:

   SHOW CLIENT_STATISTICS;
   SHOW INDEX_STATISTICS;
   SHOW TABLE_STATISTICS;
   SHOW USER_STATISTICS;
   

4. Run the following commands to flush the statistics by resetting the statistics counters to zero:

   FLUSH CLIENT_STATISTICS;
   FLUSH INDEX_STATISTICS;
   FLUSH TABLE_STATISTICS;
   FLUSH USER_STATISTICS;
   

How it works...

Extended statistics collection is off by default so that it does not cause unnecessary or unwanted load on the server. Enabling it is easy though and if desired, statistics gathering...