diff options
author | Haidong Ji <ji@haidongji.com> | 2021-05-02 15:43:04 -0500 |
---|---|---|
committer | Vicențiu Ciorbaru <cvicentiu@gmail.com> | 2021-09-07 08:45:19 +0300 |
commit | 528abc749e8a65674dd10f59a2d99d7841709939 (patch) | |
tree | db00b716196529419217427dd649cc69596322bc /mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result | |
parent | edde990e35f4760e419bad1f0cb5b57ea9e2f863 (diff) | |
download | mariadb-git-528abc749e8a65674dd10f59a2d99d7841709939.tar.gz |
MDEV-25325 built-in documentation for performance_schema tables
Improve documentation of performance_schema tables by appending COLUMN
comments to tables. Additionally improve test coverage and update corresponding
tests.
Diffstat (limited to 'mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result b/mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result index 3fa3deedaef..6cfc44961b9 100644 --- a/mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result +++ b/mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result @@ -27,3 +27,17 @@ UNLOCK TABLES; LOCK TABLES performance_schema.events_waits_summary_by_user_by_event_name WRITE; ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'events_waits_summary_by_user_by_event_name' UNLOCK TABLES; +# +# MDEV-25325 column_comment for performance_schema tables +# +select column_name, column_comment +from information_schema.columns +where table_schema='performance_schema' and table_name='events_waits_summary_by_user_by_event_name'; +column_name column_comment +USER User. Used together with EVENT_NAME for grouping events. +EVENT_NAME Event name. Used together with USER for grouping events. +COUNT_STAR Number of summarized events +SUM_TIMER_WAIT Total wait time of the summarized events that are timed. +MIN_TIMER_WAIT Minimum wait time of the summarized events that are timed. +AVG_TIMER_WAIT Average wait time of the summarized events that are timed. +MAX_TIMER_WAIT Maximum wait time of the summarized events that are timed. |