| 1 |
select * from performance_schema.events_statements_history_long |
| 2 |
where event_name like 'statement/%' limit 1; |
| 3 |
select * from performance_schema.events_statements_history_long |
| 4 |
where event_name='FOO'; |
| 5 |
select * from performance_schema.events_statements_history_long |
| 6 |
where event_name like 'statement/%' order by timer_wait limit 1; |
| 7 |
select * from performance_schema.events_statements_history_long |
| 8 |
where event_name like 'statement/%' order by timer_wait desc limit 1; |
| 9 |
insert into performance_schema.events_statements_history_long |
| 10 |
set thread_id='1', event_id=1, |
| 11 |
event_name='FOO', timer_start=1, timer_end=2, timer_wait=3; |
| 12 |
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`events_statements_history_long` |
| 13 |
update performance_schema.events_statements_history_long |
| 14 |
set timer_start=12; |
| 15 |
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`events_statements_history_long` |
| 16 |
update performance_schema.events_statements_history_long |
| 17 |
set timer_start=12 where thread_id=0; |
| 18 |
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`events_statements_history_long` |
| 19 |
delete from performance_schema.events_statements_history_long |
| 20 |
where thread_id=1; |
| 21 |
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`events_statements_history_long` |
| 22 |
delete from performance_schema.events_statements_history_long; |
| 23 |
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`events_statements_history_long` |
| 24 |
LOCK TABLES performance_schema.events_statements_history_long READ; |
| 25 |
ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`events_statements_history_long` |
| 26 |
UNLOCK TABLES; |
| 27 |
LOCK TABLES performance_schema.events_statements_history_long WRITE; |
| 28 |
ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`events_statements_history_long` |
| 29 |
UNLOCK TABLES; |
| 30 |
# |
| 31 |
# MDEV-25325 column_comment for performance_schema tables |
| 32 |
# |
| 33 |
select column_name, column_comment |
| 34 |
from information_schema.columns |
| 35 |
where table_schema='performance_schema' and table_name='events_statements_history_long'; |
| 36 |
column_name column_comment |
| 37 |
THREAD_ID Thread associated with the event. Together with EVENT_ID uniquely identifies the row. |
| 38 |
EVENT_ID Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row. |
| 39 |
END_EVENT_ID NULL when the event starts, set to the thread's current event number at the end of the event. |
| 40 |
EVENT_NAME Event instrument name and a NAME from the setup_instruments table |
| 41 |
SOURCE Name and line number of the source file containing the instrumented code that produced the event. |
| 42 |
TIMER_START Value in picoseconds when the event timing started or NULL if timing is not collected. |
| 43 |
TIMER_END Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected. |
| 44 |
TIMER_WAIT Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected. |
| 45 |
LOCK_TIME Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings. |
| 46 |
SQL_TEXT The SQL statement, or NULL if the command is not associated with an SQL statement. |
| 47 |
DIGEST Statement digest. |
| 48 |
DIGEST_TEXT Statement digest text. |
| 49 |
CURRENT_SCHEMA Statement's default database for the statement, or NULL if there was none. |
| 50 |
OBJECT_TYPE NULL for top level statements. The parent statement object type for nested statements (stored programs). |
| 51 |
OBJECT_SCHEMA NULL for top level statements. The parent statement object schema for nested statements (stored programs). |
| 52 |
OBJECT_NAME NULL for top level statements. The parent statement object name for nested statements (stored programs). |
| 53 |
OBJECT_INSTANCE_BEGIN Address in memory of the statement object. |
| 54 |
MYSQL_ERRNO Error code. See MariaDB Error Codes for a full list. |
| 55 |
RETURNED_SQLSTATE The SQLSTATE value. |
| 56 |
MESSAGE_TEXT Statement error message. See MariaDB Error Codes. |
| 57 |
ERRORS 0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1. |
| 58 |
WARNINGS Number of warnings from the diagnostics area. |
| 59 |
ROWS_AFFECTED Number of rows affected the statement affected. |
| 60 |
ROWS_SENT Number of rows returned. |
| 61 |
ROWS_EXAMINED Number of rows read during the statement's execution. |
| 62 |
CREATED_TMP_DISK_TABLES Number of on-disk temp tables created by the statement. |
| 63 |
CREATED_TMP_TABLES Number of temp tables created by the statement. |
| 64 |
SELECT_FULL_JOIN Number of joins performed by the statement which did not use an index. |
| 65 |
SELECT_FULL_RANGE_JOIN Number of joins performed by the statement which used a range search of the first table. |
| 66 |
SELECT_RANGE Number of joins performed by the statement which used a range of the first table. |
| 67 |
SELECT_RANGE_CHECK Number of joins without keys performed by the statement that check for key usage after each row. |
| 68 |
SELECT_SCAN Number of joins performed by the statement which used a full scan of the first table. |
| 69 |
SORT_MERGE_PASSES Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the sort_buffer_size. |
| 70 |
SORT_RANGE Number of sorts performed by the statement which used a range. |
| 71 |
SORT_ROWS Number of rows sorted by the statement. |
| 72 |
SORT_SCAN Number of sorts performed by the statement which used a full table scan. |
| 73 |
NO_INDEX_USED 0 if the statement performed a table scan with an index, 1 if without an index. |
| 74 |
NO_GOOD_INDEX_USED 0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the EXPLAIN article. |
| 75 |
NESTING_EVENT_ID NULL for top level statements. The parent statement event id for nested statements (stored programs). |
| 76 |
NESTING_EVENT_TYPE NULL for top level statements. The parent statement event type for nested statements (stored programs). |
| 77 |
NESTING_EVENT_LEVEL 0 for top level statements. The parent statement level plus 1 for nested statements (stored programs). |