dungmanh88 · November 15, 2016 07:53
diff --git a/Profiling mysql query b/Profiling mysql query
 mysql> set profiling=1;
 mysql> // command
 mysql> show profiles;
 mysql> show profile for query 1;
 mysql> set @query_id=1;
 mysql> SELECT STATE, SUM(DURATION) AS Total_R, ROUND(100 * SUM(DURATION) / (SELECT SUM(DURATION) FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = @query_id), 2) AS Pct_R, COUNT(*) AS Calls, SUM(DURATION) / COUNT(*) AS "R/Call" FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = @query_id GROUP BY STATE ORDER BY Total_R DESC;
	mysql> set profiling=1;
	mysql> // command
	mysql> show profiles;
	mysql> show profile for query 1;
	mysql> set @query_id=1;
	mysql> SELECT STATE, SUM(DURATION) AS Total_R, ROUND(100 * SUM(DURATION) / (SELECT SUM(DURATION) FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = @query_id), 2) AS Pct_R, COUNT() AS Calls, SUM(DURATION) / COUNT() AS "R/Call" FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = @query_id GROUP BY STATE ORDER BY Total_R DESC;