Oracle 5.0, Справочное руководство

Страница: 1741 / 3232

The
INFORMATION_SCHEMA PROFILING
Table
1721
s1 INT,
s2 INT,
s3 INT,
KEY(s1),
CONSTRAINT CO FOREIGN KEY (s2) REFERENCES t1(s3)
) ENGINE=InnoDB;
For those two tables, the
KEY_COLUMN_USAGE
table has two rows:
• One row with
CONSTRAINT_NAME
=
'PRIMARY'
,
TABLE_NAME
=
't1'
,
COLUMN_NAME
=
's3'
,
ORDINAL_POSITION
=
1
,
POSITION_IN_UNIQUE_CONSTRAINT
=
NULL
.
• One row with
CONSTRAINT_NAME
=
'CO'
,
TABLE_NAME
=
't3'
,
COLUMN_NAME
=
's2'
,
ORDINAL_POSITION
=
1
,
POSITION_IN_UNIQUE_CONSTRAINT
=
1
.
•
REFERENCED_TABLE_SCHEMA
,
REFERENCED_TABLE_NAME
, and
REFERENCED_COLUMN_NAME
were added in MySQL 5.0.6.
19.7. The
INFORMATION_SCHEMA PROFILING
Table
The
PROFILING
table provides statement profiling information. Its contents correspond to the
information produced by the
SHOW PROFILES
and
SHOW PROFILE
statements (see Section 13.7.5.29,
“
SHOW PROFILES
Syntax” ). The table is empty unless the
profiling
[483] 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.0.37.
•
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.