mysql5.7 trace_mysql中的trace工具

mysql从5.0.37后开始支持show profiles语法，用来对sql语句进行trace跟踪，下面是mysql help中对show profiles的解释：

mysql> ? show profiles;

Name: 'SHOW PROFILES'

Description:

Syntax:

SHOW PROFILES

SHOW PROFILE [type [, type] ... ]

[FOR QUERY n]

[LIMIT n [OFFSET n]]

type:

ALL

| BLOCK IO

| CONTEXT SWITCHES

| CPU

| IPC

| MEMORY

| PAGE FAULTS

| SOURCE

| SWAPS

The SHOW PROFILES and SHOW PROFILE statements display profiling

information that indicates resource usage for statements executed

during the course of the current session.

Profiling is controlled by the profiling session variable, which has a

default value of 0 (OFF). Profiling is enabled by setting profiling to

1 or ON:

mysql> SET profiling = 1;

SHOW PROFILES displays a list of the most recent statements sent to the

master. The size of the list is controlled by the

profiling_history_size session variable, which has a default value of

15. The maximum value is 100. Setting the value to 0 has the practical

effect of disabling profiling.