The PROFILING
table provides
statement profiling information. Its contents correspond to the
information produced by the SHOW
PROFILES
and SHOW PROFILE
statements (see Section 12.4.5.33, “SHOW PROFILES
Syntax”). The table is
empty unless the profiling
session variable is set to 1.
INFORMATION_SCHEMA
Name |
SHOW
Name |
Remarks |
QUERY_ID |
Query_ID |
|
SEQ |
|
|
STATE |
Status |
|
DURATION |
Duration |
|
CPU_USER |
CPU_user |
|
CPU_SYSTEM |
CPU_system |
|
CONTEXT_VOLUNTARY |
Context_voluntary |
|
CONTEXT_INVOLUNTARY |
Context_involuntary |
|
BLOCK_OPS_IN |
Block_ops_in |
|
BLOCK_OPS_OUT |
Block_ops_out |
|
MESSAGES_SENT |
Messages_sent |
|
MESSAGES_RECEIVED |
Messages_received |
|
PAGE_FAULTS_MAJOR |
Page_faults_major |
|
PAGE_FAULTS_MINOR |
Page_faults_minor |
|
SWAPS |
Swaps |
|
SOURCE_FUNCTION |
Source_function |
|
SOURCE_FILE |
Source_file |
|
SOURCE_LINE |
Source_line |
Notes:
The PROFILING
table was added in
MySQL 5.1.24 but contains no information unless the
SHOW PROFILE
feature is
enabled. The SHOW PROFILE
feature is not included in binary distributions by default
until MySQL 5.1.28.
QUERY_ID
is a numeric statement identifier.
SEQ
is a sequence number indicating the
display order for rows with the same
QUERY_ID
value.
STATE
is the profiling state to which the
row measurements apply.
DURATION
indicates how long statement
execution remained in the given state, in seconds.
CPU_USER
and CPU_SYSTEM
indicate user and system CPU use, in seconds.
CONTEXT_VOLUNTARY
and
CONTEXT_INVOLUNTARY
indicate how many
voluntary and involuntary context switches occurred.
BLOCK_OPS_IN
and
BLOCK_OPS_OUT
indicate the number of block
input and output operations.
MESSAGES_SENT
and
MESSAGES_RECEIVED
indicate the number of
communication messages sent and received.
PAGE_FAULTS_MAJOR
and
PAGE_FAULTS_MINOR
indicate the number of
major and minor page faults.
SWAPS
indicates how many swaps occurred.
SOURCE_FUNCTION
,
SOURCE_FILE
, and
SOURCE_LINE
provide information indicating
where in the source code the profiled state executes.
User Comments
Add your own comment.