Mysql Self-band profiling performance analysis tools use sharing _mysql

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

2. Set profiling=1; (open profiling)

3. Execute SQL query

Example: Select Goods_name from Ecs_goods where goods_id <5000;

Show Profiles;

4. Show profiles 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