Re: How to get the response time of each query in Mysql?
Posted by: Rick James
Date: March 04, 2016 11:55PM

Plan A: You instrument your code. In PHP, microtime(true) is handy.

Plan B: Set long_query_time = 0 and look in the slowlog afterwards. (Note: you need the FILE option, not TABLE, in order to get fraction seconds.)

Options: ReplyQuote


Subject
Written By
Posted
Re: How to get the response time of each query in Mysql?
March 04, 2016 11:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.