I am working for Query profiling. On MySQL Client I executed these three statements
SET PROFILING=ON; SELECT COUNT(*) FROM EMP; SHOW PROFILES;
It gives me desired result as :
Query_ID Execution_Time Query_Statement 1 0.01234 SELECT COUNT(*) FROM EMP;
Now I moved to MySQL Server and want to check more information about this Query execution. And Server show
can anyone please help me how I can get results on both terminals to check
profile information for each query.
SELECT * FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 1;