|
|
1 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The address in memory of the instrumented prepared statement.
|
|
|
|
2 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The internal statement ID assigned by the server.
|
|
|
|
3 |
|
varchar(64)
|
utf8mb3_general_ci
|
|
Yes |
NULL |
For the binary protocol, this column is NULL. For the text protocol, this column is the external statement name assigned by the user.
|
|
|
|
4 |
|
longtext
|
utf8mb3_general_ci
|
|
No |
None |
The prepared statement text, with ? placeholder markers.
|
|
|
|
5 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Event thread id that created the prepared statement.
|
|
|
|
6 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Event id that created the prepared statement.
|
|
|
|
7 |
|
enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'T...
|
utf8mb3_general_ci
|
|
Yes |
NULL |
NULL for a prepared statement created by a client session. Type of the stored program that created the prepared statement.
|
|
|
|
8 |
|
varchar(64)
|
utf8mb3_general_ci
|
|
Yes |
NULL |
NULL for a prepared statement created by a client session. Schema of the stored program that created the prepared statement.
|
|
|
|
9 |
|
varchar(64)
|
utf8mb3_general_ci
|
|
Yes |
NULL |
NULL for a prepared statement created by a client session. Name of the stored program that created the prepared statement.
|
|
|
|
10 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The time spent executing the statement preparation itself.
|
|
|
|
11 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The number of times the statement was reprepared internally.
|
|
|
|
12 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Total times the prepared statement was executed.
|
|
|
|
13 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Total time spent executing all prepared statements.
|
|
|
|
14 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Minimum time spent executing any of the prepared statements.
|
|
|
|
15 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Average time spent executing any of the prepared statements.
|
|
|
|
16 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Maximum time spent executing any of the prepared statements.
|
|
|
|
17 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total time spent (in picoseconds) waiting for table locks for the prepared statements.
|
|
|
|
18 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of errors that occurend for the prepared statements.
|
|
|
|
19 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of warnings that occurend for the prepared statements.
|
|
|
|
20 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of affected rows by the prepared statements.
|
|
|
|
21 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of rows returned by the prepared statements.
|
|
|
|
22 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of rows examined by the prepared statements.
|
|
|
|
23 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of on-disk temporary tables created by the prepared statements.
|
|
|
|
24 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of in-memory temporary tables created by the prepared statements.
|
|
|
|
25 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of full joins executed by the prepared statements.
|
|
|
|
26 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of range search joins executed by the prepared statements.
|
|
|
|
27 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of joins that used ranges on the first table executed by the prepared statements.
|
|
|
|
28 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of joins that check for key usage after each row executed by the prepared statements.
|
|
|
|
29 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of joins that did a full scan of the first table executed by the prepared statements.
|
|
|
|
30 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of merge passes that the sort algorithm has had to do for the prepared statements.
|
|
|
|
31 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of sorts that were done using ranges for the prepared statements.
|
|
|
|
32 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of sorted rows that were sorted by the prepared statements.
|
|
|
|
33 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of sorts that were done by scanning the table by the prepared statements.
|
|
|
|
34 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of statements that performed a table scan without using an index.
|
|
|
|
35 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of statements where no good index was found.
|
|