Home >Database >Mysql Tutorial >How can we understand the performance of the server from the output of MySQL?

How can we understand the performance of the server from the output of MySQL?

PHPz
PHPzforward
2023-09-07 16:57:02649browse

How can we understand the performance of the server from the output of MySQL?

After running a query, MySQL returns the number of rows and gives a time in the output, showing how long it took to run the query. For example, if we run the following query

mysql> create table e1(id int);
Query OK, 0 rows affected (0.23 sec)

it is displaying the time (0.23 seconds).

The above is the detailed content of How can we understand the performance of the server from the output of MySQL?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete