mysql的profiling

mysql的profiling
1，开启profile
SET profiling = 1;
2，查看共有多少query
SHOW PROFILES;
3， 查看具体某个query的信息：
show profile for query n
具体用法：
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
}

例如·：
show profile (等于show profile for query n; n=last query number)
show profile for query 1
show profile for query 2
show profile cpu for query 2
show profile all for query 2

4,查询information_schema.profiling 也可得到相应信息
5，相关参数
profiling_history_size

Warning ： ‘SHOW PROFILES’ is deprecated and will be removed in a future release. Please use Performance Schema instead