Shulou(Shulou.com)06/01 Report--

How to check the run time of mysql statements? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The way to view the run time of the mysql statement: use timestampdiff to view the execution time, the code is [select * from comment;select timestampdiff (second,@d,now ());].

How to view the run time of mysql statements:

Use timestampdiff to see the execution time.

One thing to pay attention to in this method is that the three sql statements should be executed together as far as possible, otherwise the error is too big to be allowed at all.

Set @ d=now (); select * from comment;select timestampdiff (second,@d,now ())

If you are using the command line to execute, one thing to note is that it is in select timestampdiff (second,@d,now ()); after that, be sure to copy one more blank line, otherwise the last sql will require you to press enter, which will not be allowed.

Thank you for reading! After reading the above, do you have a general idea of how to check the running time of mysql statements? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.