How to check mySQL query speed?

Question

I have a choice and a request as shown below ...

$sql = "SELECT * FROM notifications WHERE to_id='".$userid."' AND (alert_read != '1' OR user_read != '1') ORDER BY alert_time DESC"; $result = mysql_query($sql); 

How to check the deadline for the request?

Answer 1

There is a MySQL profiling system variable that is created in the INFORMATION_SCHEMA database for your specific session. See code below:

 mysql> set profiling=1; 

Just execute the query ... the query execution session will be saved to INFORMATION_SCHEMA .

 mysql> select count(*) from client where broker_id=2; 

Once the request is complete, simply run the following line:

 mysql> show profiles; 

which shows the total query execution time. Just execute and provide the request id as shown below to get the execution / speed of your request.

mysql> show profile for query 1;

Answer 2

use the php microtime () function before and after mysql_query, and then compare the results.

 $time1 = (int) microtime(); $result = mysql_query($sql); $time2 = (int) microtime(); echo ($time2 - $time1); 

(if you use microtime (true) - which returns a floating point number, you will get fewer points)

Answer 3

If you run the query from the mysql console, the speed will be displayed immediately after the query is launched.

Answer 4

You can look at this discussion:

How to check MySQL query speed with less inconsistencies?