Mysql built-in profiling Performance Analysis Tool

Mysql built-in profiling performance analysis tool 1. show variables like '% profiling %'; (view profiling information) www.2cto.com

2. set profiling = 1; (enable profiling)

3. Run the SQL query example: select goods_name from ecs_goods where goods_id <5000; show profiles;
4. show profile for query 4;

The format of show profile is as follows: show profile [type [, type]...] [for query n] [LIMIT row_count [OFFSET offset] type: ALL | block io | context switches | CPU | IPC | MEMORY | page faults | SOURCE | SWAPS