Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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!