How to view the running time of MySQL statements through Query Profiler

The previous article introduced two methods to check the running time of MySQL statements. Today, I will continue to introduce you to check the running time of MySQL statements. Interested friends, let’s learn together!

Query Profiler is a query diagnostic analysis tool that comes with MYSQL. It can be used to analyze the performance bottleneck of a SQL statement. Usually we use explain and slow query log, but they cannot provide accurate analysis.

However, Query Profiler can locate the various resource consumption of a SQL statement, such as CPU, IO, etc., as well as the time consumed by the SQL execution.

Show profiles was added after 5.0.37. To use this feature, make sure the version is after 5.0.37.

1. Log in to MySQL to view the database version:
Login: mysql -u username -p
use databses the database you want to choose: use databses

View the version: show variables like "%version%"; 或者select version();

2. Check whether the profile is enabled. The database is not enabled by default.

View method: show variables like "%pro%";
Setting the start method: set profiling = 1;

You can start executing some SQL statements you want to analyze.

3. After execution, query the SQL execution time: show profiles；
You can view the total execution time of all SQL.

Supplement: show profile cpu, block io, memory, swaps, context switches, source for query 6; you can view the various resource consumption of a SQL statement, such as CPU, IO, etc.

This is the end of this article about how to view the execution time of MySQL statements through Query Profiler. For more information about viewing the execution time of MySQL statements, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!