MySQL comes with profiling performance analysis tool using share

1. Show variables like '%profiling% ';(View profiling information)

2. Set profiling=1; (Turn on profiling)

3. Execute 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

MySQL comes with profiling performance analysis tool using share