Thursday, March 21, 2013

Query Profile in mysql

show variables like 'profiling';

set profiling = 1;

show variables like 'profiling';

select * from employees where emp_no =10001;


show profiles;

show profile cpu for query [query number];


No comments:

Post a Comment