To get the execution time of a MYSQL query in Query

Question

I am developing a query browser, working with some large database, and I need to know the time taken to complete the query.

I see the time when the request succeeds in PHPMYADMIN.

Profiling or Showing rows 0 - 29 (2,000 total, Query took 0.0145 sec)

Example: Profiling

 SELECT * FROM `larger_table`; Status Time starting 0.000026 checking permissions 0.000006 Opening tables 0.000014 System lock 0.000010 init 0.000022 optimizing 0.000004 statistics 0.000007 preparing 0.000005 executing 0.000001 Sending data 0.014138 end 0.000004 query end 0.000002 closing tables 0.000005 freeing items 0.000091 logging slow query 0.000003 cleaning up 0.000002 

In the query browser, I see the time it takes at the bottom of the browser window.

So, how can I get the execution time of a request when sending a request to execute.

ie When I give the following request:

 SELECT * FROM `larger_table`; 

The request should return its execution time.

I have to catch this in PHP and show it to users. When the user gives some request for execution in the browser.

Is there any way to find the query execution time.?

Please check the images on which I noted the estimated time.

I found something. Note this.

Answer 1

Please use the code below

 $sql_query = 'SELECT * FROM larger_table'; $msc = microtime(true); mysql_query($sql_query); $msc = microtime(true) - $msc; echo $msc . ' seconds'; // in seconds echo ($msc * 1000) . ' milliseconds'; // in millseconds 

Answer 2

Look below -

 $sql_query='SELECT * FROM tablename'; $result = mysql_query($query); $exec_time_result=mysql_query("SELECT query_id, SUM(duration) FROM information_schema.profiling GROUP BY query_id ORDER BY query_id DESC LIMIT 1;"); if (mysql_errno()) { die( "ERROR ".mysql_errno($link) . ": " . mysql_error($link) ); } $exec_time_row = mysql_fetch_array($exec_time_result); echo "<p>Query executed in ".$exec_time_row[1].' seconds'; 

OutPut - Request completed in 0.000121 seconds.

Answer 3

http://ftp.nchu.edu.tw/MySQL/tech-resources/articles/using-new-query-profiler.html

can this link be useful for profiling a request