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];


Comments

Popular posts from this blog

Bucket Sort in python

codefights smooth sailing ( CommonCharacterCount)