How can we get an idea about the server performance from the output of MySQL?

After running a query, MySQL returns the number of rows and gives time in the output that shows how much it took for running that query. As for example, if we run the following query

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

It is showing the time (0.23 sec).

Updated on: 11-Feb-2020


Kickstart Your Career

Get certified by completing the course

Get Started