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
About the Author
About the Reviewers


Profiling permits you to benchmark information that indicates resource usages during a session. This is used when we want to get information on a specified query. Here are the types of information:

  • Block I/O

  • Context switches

  • CPU

  • IPC

  • Memory

  • Page faults

  • Source

  • Swaps

  • All

First of all, you need to know that profiling on a production server is not recommended because of the performance degradation it can cause.

To enable profiling, use the following command:

MariaDB [none]> SET PROFILING=1;

Perform all the query tasks you want to profile and then list them:

MariaDB [none]> SHOW PROFILES;
| Query_ID | Duration   | Query                   |
|        1 | 0.30798532 | select * from s_explain |
|        2 | 0.25341312 | select * from s_explain |

In the preceding command-line output, you can see that we've two query IDs. To get information...