Resetting statistics

In this chapter, we'll play with the MariaDB statistics. Sometimes, you'll need to reset them. You have two choices to do so:

• Do it on the fly

• Make the change on the configuration file and restart the MariaDB instance

We'll see here how to flush the statistics on the fly with the mysqladmin command as follows:

> mysqladmin flush-all-statistics

If you prefer using a classical command, here's one:

MariaDB [(none)]> FLUSH STATUS;

That's it!