summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result
diff options
context:
space:
mode:
authorHaidong Ji <ji@haidongji.com>2021-05-02 15:43:04 -0500
committerVicențiu Ciorbaru <cvicentiu@gmail.com>2021-09-07 08:45:19 +0300
commit528abc749e8a65674dd10f59a2d99d7841709939 (patch)
treedb00b716196529419217427dd649cc69596322bc /mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result
parentedde990e35f4760e419bad1f0cb5b57ea9e2f863 (diff)
downloadmariadb-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.result14
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.