Janak
Janak

Reputation: 5085

How can I see how long statements take to execute on the mysql command line?

When I execute statements on the mysql command line, there must be some way to always display how long the command took to execute?

Upvotes: 2

Views: 89

Answers (1)

Stefan Arentz
Stefan Arentz

Reputation: 34935

It does show that info for every command executed:

mysql> select md5('dkejde');
+----------------------------------+
| md5('dkejde')                    |
+----------------------------------+
| 3960c3b0aa4acc97ca277cdea69775fd | 
+----------------------------------+
1 row in set (0.04 sec)

mysql> show databases;
...
38 rows in set (0.29 sec)

You don't see that?

Upvotes: 4

Related Questions