You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/06/26 04:35:35 UTC
[shardingsphere] branch master updated: Add mysql sys tables (#26570)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new a5d6c92283b Add mysql sys tables (#26570)
a5d6c92283b is described below
commit a5d6c92283b5da4d0bebdd976c243cfc91e8e220
Author: ZhangCheng <ch...@apache.org>
AuthorDate: Mon Jun 26 12:35:28 2023 +0800
Add mysql sys tables (#26570)
---
.../schema/builder/SystemSchemaBuilderRule.java | 14 +-
.../resources/schema/mysql/sys/host_summary.yaml | 115 ++++++++++
.../schema/mysql/sys/host_summary_by_file_io.yaml | 43 ++++
.../mysql/sys/host_summary_by_file_io_type.yaml | 59 +++++
.../schema/mysql/sys/host_summary_by_stages.yaml | 59 +++++
.../sys/host_summary_by_statement_latency.yaml | 91 ++++++++
.../mysql/sys/host_summary_by_statement_type.yaml | 99 +++++++++
.../mysql/sys/innodb_buffer_stats_by_schema.yaml | 75 +++++++
.../mysql/sys/innodb_buffer_stats_by_table.yaml | 83 +++++++
.../schema/mysql/sys/innodb_lock_waits.yaml | 227 +++++++++++++++++++
.../schema/mysql/sys/io_by_thread_by_latency.yaml | 83 +++++++
.../mysql/sys/io_global_by_file_by_bytes.yaml | 91 ++++++++
.../mysql/sys/io_global_by_file_by_latency.yaml | 91 ++++++++
.../mysql/sys/io_global_by_wait_by_bytes.yaml | 123 +++++++++++
.../mysql/sys/io_global_by_wait_by_latency.yaml | 131 +++++++++++
.../resources/schema/mysql/sys/latest_file_io.yaml | 59 +++++
.../mysql/sys/memory_by_host_by_current_bytes.yaml | 67 ++++++
.../sys/memory_by_thread_by_current_bytes.yaml | 75 +++++++
.../mysql/sys/memory_by_user_by_current_bytes.yaml | 67 ++++++
.../mysql/sys/memory_global_by_current_bytes.yaml | 75 +++++++
.../schema/mysql/sys/memory_global_total.yaml | 27 +++
.../main/resources/schema/mysql/sys/metrics.yaml | 51 +++++
.../resources/schema/mysql/sys/processlist.yaml | 243 +++++++++++++++++++++
.../mysql/sys/ps_check_lost_instrumentation.yaml | 35 +++
.../mysql/sys/schema_auto_increment_columns.yaml | 99 +++++++++
.../schema/mysql/sys/schema_index_statistics.yaml | 107 +++++++++
.../schema/mysql/sys/schema_object_overview.yaml | 43 ++++
.../schema/mysql/sys/schema_redundant_indexes.yaml | 99 +++++++++
.../schema/mysql/sys/schema_table_lock_waits.yaml | 163 ++++++++++++++
.../schema/mysql/sys/schema_table_statistics.yaml | 171 +++++++++++++++
.../sys/schema_table_statistics_with_buffer.yaml | 219 +++++++++++++++++++
.../sys/schema_tables_with_full_table_scans.yaml | 51 +++++
.../schema/mysql/sys/schema_unused_indexes.yaml | 43 ++++
.../main/resources/schema/mysql/sys/session.yaml | 243 +++++++++++++++++++++
.../schema/mysql/sys/session_ssl_status.yaml | 51 +++++
.../schema/mysql/sys/statement_analysis.yaml | 203 +++++++++++++++++
.../sys/statements_with_errors_or_warnings.yaml | 99 +++++++++
.../sys/statements_with_full_table_scans.yaml | 131 +++++++++++
...tatements_with_runtimes_in_95th_percentile.yaml | 147 +++++++++++++
.../schema/mysql/sys/statements_with_sorting.yaml | 123 +++++++++++
.../mysql/sys/statements_with_temp_tables.yaml | 107 +++++++++
.../resources/schema/mysql/sys/user_summary.yaml | 115 ++++++++++
.../schema/mysql/sys/user_summary_by_file_io.yaml | 43 ++++
.../mysql/sys/user_summary_by_file_io_type.yaml | 59 +++++
.../schema/mysql/sys/user_summary_by_stages.yaml | 59 +++++
.../sys/user_summary_by_statement_latency.yaml | 91 ++++++++
.../mysql/sys/user_summary_by_statement_type.yaml | 99 +++++++++
.../main/resources/schema/mysql/sys/version.yaml | 35 +++
.../sys/wait_classes_global_by_avg_latency.yaml | 67 ++++++
.../mysql/sys/wait_classes_global_by_latency.yaml | 67 ++++++
.../schema/mysql/sys/waits_by_host_by_latency.yaml | 67 ++++++
.../schema/mysql/sys/waits_by_user_by_latency.yaml | 67 ++++++
.../schema/mysql/sys/waits_global_by_latency.yaml | 59 +++++
.../builder/SystemSchemaBuilderRuleTest.java | 3 +
.../schema/builder/SystemSchemaBuilderTest.java | 4 +
.../dataset/db/select_mysql_sys_host_summary.xml | 33 +++
.../select_mysql_sys_host_summary_by_file_io.xml | 24 ++
...lect_mysql_sys_host_summary_by_file_io_type.xml | 26 +++
.../db/select_mysql_sys_host_summary_by_stages.xml | 26 +++
...mysql_sys_host_summary_by_statement_latency.xml | 30 +++
...ct_mysql_sys_host_summary_by_statement_type.xml | 31 +++
...ect_mysql_sys_innodb_buffer_stats_by_schema.xml | 28 +++
...lect_mysql_sys_innodb_buffer_stats_by_table.xml | 29 +++
.../db/select_mysql_sys_innodb_lock_waits.xml | 47 ++++
.../select_mysql_sys_io_by_thread_by_latency.xml | 29 +++
...select_mysql_sys_io_global_by_file_by_bytes.xml | 30 +++
...lect_mysql_sys_io_global_by_file_by_latency.xml | 30 +++
...select_mysql_sys_io_global_by_wait_by_bytes.xml | 34 +++
...lect_mysql_sys_io_global_by_wait_by_latency.xml | 35 +++
.../dataset/db/select_mysql_sys_latest_file_io.xml | 26 +++
...t_mysql_sys_memory_by_host_by_current_bytes.xml | 27 +++
...mysql_sys_memory_by_thread_by_current_bytes.xml | 28 +++
...t_mysql_sys_memory_by_user_by_current_bytes.xml | 27 +++
...ct_mysql_sys_memory_global_by_current_bytes.xml | 28 +++
.../db/select_mysql_sys_memory_global_total.xml | 22 ++
.../dql/dataset/db/select_mysql_sys_metrics.xml | 25 +++
.../dataset/db/select_mysql_sys_processlist.xml | 49 +++++
...ect_mysql_sys_ps_check_lost_instrumentation.xml | 23 ++
...ect_mysql_sys_schema_auto_increment_columns.xml | 31 +++
.../select_mysql_sys_schema_index_statistics.xml | 32 +++
.../db/select_mysql_sys_schema_object_overview.xml | 24 ++
.../select_mysql_sys_schema_redundant_indexes.xml | 31 +++
.../select_mysql_sys_schema_table_lock_waits.xml | 39 ++++
.../select_mysql_sys_schema_table_statistics.xml | 40 ++++
...sql_sys_schema_table_statistics_with_buffer.xml | 46 ++++
...sql_sys_schema_tables_with_full_table_scans.xml | 25 +++
.../db/select_mysql_sys_schema_unused_indexes.xml | 24 ++
.../dql/dataset/db/select_mysql_sys_session.xml | 49 +++++
.../db/select_mysql_sys_session_ssl_status.xml | 25 +++
.../db/select_mysql_sys_statement_analysis.xml | 44 ++++
...ysql_sys_statements_with_errors_or_warnings.xml | 31 +++
..._mysql_sys_statements_with_full_table_scans.xml | 35 +++
...statements_with_runtimes_in_95th_percentile.xml | 37 ++++
.../select_mysql_sys_statements_with_sorting.xml | 34 +++
...elect_mysql_sys_statements_with_temp_tables.xml | 32 +++
.../dql/dataset/db/select_mysql_sys_sys_config.xml | 25 +++
.../dataset/db/select_mysql_sys_user_summary.xml | 33 +++
.../select_mysql_sys_user_summary_by_file_io.xml | 24 ++
...lect_mysql_sys_user_summary_by_file_io_type.xml | 26 +++
.../db/select_mysql_sys_user_summary_by_stages.xml | 26 +++
...mysql_sys_user_summary_by_statement_latency.xml | 30 +++
...ct_mysql_sys_user_summary_by_statement_type.xml | 31 +++
.../dql/dataset/db/select_mysql_sys_version.xml | 23 ++
...ysql_sys_wait_classes_global_by_avg_latency.xml | 27 +++
...ct_mysql_sys_wait_classes_global_by_latency.xml | 27 +++
.../select_mysql_sys_waits_by_host_by_latency.xml | 27 +++
.../select_mysql_sys_waits_by_user_by_latency.xml | 27 +++
.../select_mysql_sys_waits_global_by_latency.xml | 26 +++
.../dql/dql-integration-select-system-schema.xml | 213 ++++++++++++++++++
109 files changed, 6847 insertions(+), 1 deletion(-)
diff --git a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
index 8a929b19bb1..9e76126dad6 100644
--- a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
+++ b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
@@ -70,7 +70,19 @@ public enum SystemSchemaBuilderRule {
"socket_summary_by_event_name", "socket_summary_by_instance", "status_by_account", "status_by_host", "status_by_thread", "status_by_user", "table_handles",
"table_io_waits_summary_by_index_usage", "table_io_waits_summary_by_table", "table_lock_waits_summary_by_table", "threads", "user_variables_by_thread", "users", "variables_by_thread"))),
- MYSQL_SYS("MySQL", "sys", new HashSet<>(Collections.singleton("sys_config"))),
+ MYSQL_SYS("MySQL", "sys",
+ new HashSet<>(Arrays.asList("host_summary", "host_summary_by_file_io", "host_summary_by_file_io_type", "host_summary_by_stages", "host_summary_by_statement_latency",
+ "host_summary_by_statement_type", "innodb_buffer_stats_by_schema", "innodb_buffer_stats_by_table", "innodb_lock_waits",
+ "io_by_thread_by_latency", "io_global_by_file_by_bytes", "io_global_by_file_by_latency", "io_global_by_wait_by_bytes", "io_global_by_wait_by_latency", "latest_file_io",
+ "memory_by_host_by_current_bytes", "memory_by_thread_by_current_bytes", "memory_by_user_by_current_bytes",
+ "memory_global_by_current_bytes", "memory_global_total", "metrics", "processlist", "ps_check_lost_instrumentation", "schema_auto_increment_columns", "schema_index_statistics",
+ "schema_object_overview", "schema_redundant_indexes",
+ "schema_table_lock_waits", "schema_table_statistics", "schema_table_statistics_with_buffer", "schema_tables_with_full_table_scans", "schema_unused_indexes", "session",
+ "session_ssl_status", "statement_analysis", "statements_with_errors_or_warnings",
+ "statements_with_full_table_scans", "statements_with_runtimes_in_95th_percentile", "statements_with_sorting", "statements_with_temp_tables", "sys_config", "user_summary",
+ "user_summary_by_file_io", "user_summary_by_file_io_type", "user_summary_by_stages",
+ "user_summary_by_statement_latency", "user_summary_by_statement_type", "version", "wait_classes_global_by_avg_latency", "wait_classes_global_by_latency",
+ "waits_by_host_by_latency", "waits_by_user_by_latency", "waits_global_by_latency"))),
MYSQL_SHARDING_SPHERE("MySQL", "shardingsphere", new HashSet<>(Arrays.asList("sharding_table_statistics", "cluster_information"))),
diff --git a/infra/common/src/main/resources/schema/mysql/sys/host_summary.yaml b/infra/common/src/main/resources/schema/mysql/sys/host_summary.yaml
new file mode 100644
index 00000000000..485280407c5
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/host_summary.yaml
@@ -0,0 +1,115 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: host_summary
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statements:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: statements
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: statement_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement_avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: statement_avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_scans:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: table_scans
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_ios:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: file_ios
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_io_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: file_io_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_connections:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: current_connections
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_connections:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: total_connections
+ primaryKey: false
+ unsigned: false
+ visible: true
+ unique_users:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: unique_users
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_memory:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_memory_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_memory_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_file_io.yaml b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_file_io.yaml
new file mode 100644
index 00000000000..eeacdbc09c3
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_file_io.yaml
@@ -0,0 +1,43 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: host_summary_by_file_io
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ios:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: ios
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_file_io_type.yaml b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_file_io_type.yaml
new file mode 100644
index 00000000000..6b0bbea2404
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_file_io_type.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: host_summary_by_file_io_type
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_stages.yaml b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_stages.yaml
new file mode 100644
index 00000000000..db9a67ab943
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_stages.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: host_summary_by_stages
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_statement_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_statement_latency.yaml
new file mode 100644
index 00000000000..5cf582c2295
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_statement_latency.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: host_summary_by_statement_latency
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: lock_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_affected:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_affected
+ primaryKey: false
+ unsigned: false
+ visible: true
+ full_scans:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: full_scans
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_statement_type.yaml b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_statement_type.yaml
new file mode 100644
index 00000000000..47a17c865e8
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/host_summary_by_statement_type.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: host_summary_by_statement_type
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: statement
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: lock_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_affected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_affected
+ primaryKey: false
+ unsigned: true
+ visible: true
+ full_scans:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: full_scans
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/innodb_buffer_stats_by_schema.yaml b/infra/common/src/main/resources/schema/mysql/sys/innodb_buffer_stats_by_schema.yaml
new file mode 100644
index 00000000000..8171f5f12ee
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/innodb_buffer_stats_by_schema.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: innodb_buffer_stats_by_schema
+columns:
+ object_schema:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: data
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pages:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: pages
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pages_hashed:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: pages_hashed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pages_old:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: pages_old
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_cached:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_cached
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/innodb_buffer_stats_by_table.yaml b/infra/common/src/main/resources/schema/mysql/sys/innodb_buffer_stats_by_table.yaml
new file mode 100644
index 00000000000..37162145444
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/innodb_buffer_stats_by_table.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: innodb_buffer_stats_by_table
+columns:
+ object_schema:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: data
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pages:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: pages
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pages_hashed:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: pages_hashed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pages_old:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: pages_old
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_cached:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_cached
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/innodb_lock_waits.yaml b/infra/common/src/main/resources/schema/mysql/sys/innodb_lock_waits.yaml
new file mode 100644
index 00000000000..7b599db10d2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/innodb_lock_waits.yaml
@@ -0,0 +1,227 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: innodb_lock_waits
+columns:
+ wait_started:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: wait_started
+ primaryKey: false
+ unsigned: false
+ visible: true
+ wait_age:
+ caseSensitive: false
+ dataType: 92
+ generated: false
+ name: wait_age
+ primaryKey: false
+ unsigned: false
+ visible: true
+ wait_age_secs:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: wait_age_secs
+ primaryKey: false
+ unsigned: false
+ visible: true
+ locked_table:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: locked_table
+ primaryKey: false
+ unsigned: false
+ visible: true
+ locked_index:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: locked_index
+ primaryKey: false
+ unsigned: false
+ visible: true
+ locked_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: locked_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_trx_id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: waiting_trx_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_trx_started:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: waiting_trx_started
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_trx_age:
+ caseSensitive: false
+ dataType: 92
+ generated: false
+ name: waiting_trx_age
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_trx_rows_locked:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_trx_rows_locked
+ primaryKey: false
+ unsigned: true
+ visible: true
+ waiting_trx_rows_modified:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_trx_rows_modified
+ primaryKey: false
+ unsigned: true
+ visible: true
+ waiting_pid:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_pid
+ primaryKey: false
+ unsigned: true
+ visible: true
+ waiting_query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: waiting_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_lock_id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: waiting_lock_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_lock_mode:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: waiting_lock_mode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_trx_id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: blocking_trx_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_pid:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: blocking_pid
+ primaryKey: false
+ unsigned: true
+ visible: true
+ blocking_query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: blocking_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_lock_id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: blocking_lock_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_lock_mode:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: blocking_lock_mode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_trx_started:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: blocking_trx_started
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_trx_age:
+ caseSensitive: false
+ dataType: 92
+ generated: false
+ name: blocking_trx_age
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_trx_rows_locked:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: blocking_trx_rows_locked
+ primaryKey: false
+ unsigned: true
+ visible: true
+ blocking_trx_rows_modified:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: blocking_trx_rows_modified
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sql_kill_blocking_query:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: sql_kill_blocking_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sql_kill_blocking_connection:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: sql_kill_blocking_connection
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/io_by_thread_by_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/io_by_thread_by_latency.yaml
new file mode 100644
index 00000000000..d36219d26cd
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/io_by_thread_by_latency.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: io_by_thread_by_latency
+columns:
+ user:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: min_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: thread_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ processlist_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: processlist_id
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/io_global_by_file_by_bytes.yaml b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_file_by_bytes.yaml
new file mode 100644
index 00000000000..bac2bda9e01
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_file_by_bytes.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: io_global_by_file_by_bytes
+columns:
+ file:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: file
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_read:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_read
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_write:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_write
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_written:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_written
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_write:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_write
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: false
+ visible: true
+ write_pct:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: write_pct
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/io_global_by_file_by_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_file_by_latency.yaml
new file mode 100644
index 00000000000..57cc99891f1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_file_by_latency.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: io_global_by_file_by_latency
+columns:
+ file:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: file
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_read:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_read
+ primaryKey: false
+ unsigned: true
+ visible: true
+ read_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: read_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_write:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_write
+ primaryKey: false
+ unsigned: true
+ visible: true
+ write_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: write_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_misc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_misc
+ primaryKey: false
+ unsigned: true
+ visible: true
+ misc_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: misc_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/io_global_by_wait_by_bytes.yaml b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_wait_by_bytes.yaml
new file mode 100644
index 00000000000..20c35f51289
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_wait_by_bytes.yaml
@@ -0,0 +1,123 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: io_global_by_wait_by_bytes
+columns:
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: min_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_read:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_read
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_write:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_write
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_written:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_written
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_written:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_written
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_requested:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_requested
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/io_global_by_wait_by_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_wait_by_latency.yaml
new file mode 100644
index 00000000000..3118849559f
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/io_global_by_wait_by_latency.yaml
@@ -0,0 +1,131 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: io_global_by_wait_by_latency
+columns:
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ read_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: read_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ write_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: write_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ misc_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: misc_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_read:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_read
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_write:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count_write
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_written:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_written
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_written:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_written
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/latest_file_io.yaml b/infra/common/src/main/resources/schema/mysql/sys/latest_file_io.yaml
new file mode 100644
index 00000000000..fd7d487677a
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/latest_file_io.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: latest_file_io
+columns:
+ thread:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: thread
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: file
+ primaryKey: false
+ unsigned: false
+ visible: true
+ latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ operation:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: operation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ requested:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: requested
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/memory_by_host_by_current_bytes.yaml b/infra/common/src/main/resources/schema/mysql/sys/memory_by_host_by_current_bytes.yaml
new file mode 100644
index 00000000000..30d6301076d
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/memory_by_host_by_current_bytes.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: memory_by_host_by_current_bytes
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: current_count_used
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_avg_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_avg_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_max_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_max_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/memory_by_thread_by_current_bytes.yaml b/infra/common/src/main/resources/schema/mysql/sys/memory_by_thread_by_current_bytes.yaml
new file mode 100644
index 00000000000..2ed87e63ffb
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/memory_by_thread_by_current_bytes.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: memory_by_thread_by_current_bytes
+columns:
+ thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: thread_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ user:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: current_count_used
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_avg_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_avg_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_max_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_max_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/memory_by_user_by_current_bytes.yaml b/infra/common/src/main/resources/schema/mysql/sys/memory_by_user_by_current_bytes.yaml
new file mode 100644
index 00000000000..2fcf13235fe
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/memory_by_user_by_current_bytes.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: memory_by_user_by_current_bytes
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: current_count_used
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_avg_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_avg_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_max_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_max_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/memory_global_by_current_bytes.yaml b/infra/common/src/main/resources/schema/mysql/sys/memory_global_by_current_bytes.yaml
new file mode 100644
index 00000000000..7dafc4f586c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/memory_global_by_current_bytes.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: memory_global_by_current_bytes
+columns:
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: current_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_avg_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_avg_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: high_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: high_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_avg_alloc:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: high_avg_alloc
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/memory_global_total.yaml b/infra/common/src/main/resources/schema/mysql/sys/memory_global_total.yaml
new file mode 100644
index 00000000000..6911751430d
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/memory_global_total.yaml
@@ -0,0 +1,27 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: memory_global_total
+columns:
+ total_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/metrics.yaml b/infra/common/src/main/resources/schema/mysql/sys/metrics.yaml
new file mode 100644
index 00000000000..10d4639062c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/metrics.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: metrics
+columns:
+ variable_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: Variable_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ variable_value:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: Variable_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: Type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ enabled:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: Enabled
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/processlist.yaml b/infra/common/src/main/resources/schema/mysql/sys/processlist.yaml
new file mode 100644
index 00000000000..589a63995b2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/processlist.yaml
@@ -0,0 +1,243 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: processlist
+columns:
+ thd_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: thd_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ conn_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: conn_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ user:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ command:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: command
+ primaryKey: false
+ unsigned: false
+ visible: true
+ state:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: state
+ primaryKey: false
+ unsigned: false
+ visible: true
+ time:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_statement:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_statement
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: statement_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ progress:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: progress
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: lock_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_affected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_affected
+ primaryKey: false
+ unsigned: true
+ visible: true
+ tmp_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: tmp_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ tmp_disk_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: tmp_disk_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ full_scan:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: full_scan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_statement:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: last_statement
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_statement_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: last_statement_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_memory:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_wait:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: last_wait
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_wait_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: last_wait_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ source:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: source
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: trx_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_state:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_state
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_autocommit:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_autocommit
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ program_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: program_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/ps_check_lost_instrumentation.yaml b/infra/common/src/main/resources/schema/mysql/sys/ps_check_lost_instrumentation.yaml
new file mode 100644
index 00000000000..a556b9e8b89
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/ps_check_lost_instrumentation.yaml
@@ -0,0 +1,35 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: ps_check_lost_instrumentation
+columns:
+ variable_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: variable_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ variable_value:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: variable_value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_auto_increment_columns.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_auto_increment_columns.yaml
new file mode 100644
index 00000000000..6b85ac1d726
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_auto_increment_columns.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_auto_increment_columns
+columns:
+ table_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_type:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: column_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_signed:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: is_signed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_unsigned:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: is_unsigned
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_value:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: max_value
+ primaryKey: false
+ unsigned: true
+ visible: true
+ auto_increment:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: auto_increment
+ primaryKey: false
+ unsigned: true
+ visible: true
+ auto_increment_ratio:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: auto_increment_ratio
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_index_statistics.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_index_statistics.yaml
new file mode 100644
index 00000000000..f9f3f5dcddc
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_index_statistics.yaml
@@ -0,0 +1,107 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_index_statistics
+columns:
+ table_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ index_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: index_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_selected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_selected
+ primaryKey: false
+ unsigned: true
+ visible: true
+ select_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: select_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_inserted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_inserted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ insert_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: insert_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_updated:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_updated
+ primaryKey: false
+ unsigned: true
+ visible: true
+ update_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: update_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_deleted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_deleted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ delete_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: delete_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_object_overview.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_object_overview.yaml
new file mode 100644
index 00000000000..3d2682151ae
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_object_overview.yaml
@@ -0,0 +1,43 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_object_overview
+columns:
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: object_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: count
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_redundant_indexes.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_redundant_indexes.yaml
new file mode 100644
index 00000000000..1b128543453
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_redundant_indexes.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_redundant_indexes
+columns:
+ table_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ redundant_index_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: redundant_index_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ redundant_index_columns:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: redundant_index_columns
+ primaryKey: false
+ unsigned: false
+ visible: true
+ redundant_index_non_unique:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: redundant_index_non_unique
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dominant_index_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: dominant_index_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dominant_index_columns:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: dominant_index_columns
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dominant_index_non_unique:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: dominant_index_non_unique
+ primaryKey: false
+ unsigned: false
+ visible: true
+ subpart_exists:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: subpart_exists
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sql_drop_index:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: sql_drop_index
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_table_lock_waits.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_table_lock_waits.yaml
new file mode 100644
index 00000000000..cec4bec310d
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_table_lock_waits.yaml
@@ -0,0 +1,163 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_table_lock_waits
+columns:
+ object_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_thread_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ waiting_pid:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_pid
+ primaryKey: false
+ unsigned: true
+ visible: true
+ waiting_account:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: waiting_account
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_lock_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: waiting_lock_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_lock_duration:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: waiting_lock_duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: waiting_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_query_secs:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_query_secs
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_query_rows_affected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_query_rows_affected
+ primaryKey: false
+ unsigned: true
+ visible: true
+ waiting_query_rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: waiting_query_rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ blocking_thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: blocking_thread_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ blocking_pid:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: blocking_pid
+ primaryKey: false
+ unsigned: true
+ visible: true
+ blocking_account:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: blocking_account
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_lock_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: blocking_lock_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ blocking_lock_duration:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: blocking_lock_duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sql_kill_blocking_query:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: sql_kill_blocking_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sql_kill_blocking_connection:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: sql_kill_blocking_connection
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_table_statistics.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_table_statistics.yaml
new file mode 100644
index 00000000000..0112f9ad913
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_table_statistics.yaml
@@ -0,0 +1,171 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_table_statistics
+columns:
+ table_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_fetched:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_fetched
+ primaryKey: false
+ unsigned: true
+ visible: true
+ fetch_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: fetch_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_inserted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_inserted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ insert_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: insert_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_updated:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_updated
+ primaryKey: false
+ unsigned: true
+ visible: true
+ update_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: update_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_deleted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_deleted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ delete_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: delete_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_read_requests:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: io_read_requests
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_read_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_read_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_write_requests:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: io_write_requests
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_write:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_write
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_write_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_write_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_misc_requests:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: io_misc_requests
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_misc_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_misc_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_table_statistics_with_buffer.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_table_statistics_with_buffer.yaml
new file mode 100644
index 00000000000..4ceb192af46
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_table_statistics_with_buffer.yaml
@@ -0,0 +1,219 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_table_statistics_with_buffer
+columns:
+ table_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_fetched:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_fetched
+ primaryKey: false
+ unsigned: true
+ visible: true
+ fetch_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: fetch_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_inserted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_inserted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ insert_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: insert_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_updated:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_updated
+ primaryKey: false
+ unsigned: true
+ visible: true
+ update_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: update_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_deleted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_deleted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ delete_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: delete_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_read_requests:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: io_read_requests
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_read:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_read_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_read_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_write_requests:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: io_write_requests
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_write:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_write
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_write_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_write_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_misc_requests:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: io_misc_requests
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_misc_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_misc_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ innodb_buffer_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: innodb_buffer_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ innodb_buffer_data:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: innodb_buffer_data
+ primaryKey: false
+ unsigned: false
+ visible: true
+ innodb_buffer_free:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: innodb_buffer_free
+ primaryKey: false
+ unsigned: false
+ visible: true
+ innodb_buffer_pages:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: innodb_buffer_pages
+ primaryKey: false
+ unsigned: false
+ visible: true
+ innodb_buffer_pages_hashed:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: innodb_buffer_pages_hashed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ innodb_buffer_pages_old:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: innodb_buffer_pages_old
+ primaryKey: false
+ unsigned: false
+ visible: true
+ innodb_buffer_rows_cached:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: innodb_buffer_rows_cached
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_tables_with_full_table_scans.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_tables_with_full_table_scans.yaml
new file mode 100644
index 00000000000..7af7e419af3
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_tables_with_full_table_scans.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_tables_with_full_table_scans
+columns:
+ object_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_full_scanned:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_full_scanned
+ primaryKey: false
+ unsigned: true
+ visible: true
+ latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/schema_unused_indexes.yaml b/infra/common/src/main/resources/schema/mysql/sys/schema_unused_indexes.yaml
new file mode 100644
index 00000000000..3275def3ec8
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/schema_unused_indexes.yaml
@@ -0,0 +1,43 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schema_unused_indexes
+columns:
+ object_schema:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ index_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: index_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/session.yaml b/infra/common/src/main/resources/schema/mysql/sys/session.yaml
new file mode 100644
index 00000000000..84556e362c7
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/session.yaml
@@ -0,0 +1,243 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: session
+columns:
+ thd_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: thd_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ conn_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: conn_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ user:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ command:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: command
+ primaryKey: false
+ unsigned: false
+ visible: true
+ state:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: state
+ primaryKey: false
+ unsigned: false
+ visible: true
+ time:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_statement:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_statement
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: statement_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ progress:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: progress
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: lock_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_affected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_affected
+ primaryKey: false
+ unsigned: true
+ visible: true
+ tmp_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: tmp_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ tmp_disk_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: tmp_disk_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ full_scan:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: full_scan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_statement:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: last_statement
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_statement_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: last_statement_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_memory:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_wait:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: last_wait
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_wait_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: last_wait_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ source:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: source
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: trx_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_state:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_state
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_autocommit:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_autocommit
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ program_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: program_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/session_ssl_status.yaml b/infra/common/src/main/resources/schema/mysql/sys/session_ssl_status.yaml
new file mode 100644
index 00000000000..456fecff674
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/session_ssl_status.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: session_ssl_status
+columns:
+ thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: thread_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ ssl_version:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ssl_version
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ssl_cipher:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ssl_cipher
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ssl_sessions_reused:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ssl_sessions_reused
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/statement_analysis.yaml b/infra/common/src/main/resources/schema/mysql/sys/statement_analysis.yaml
new file mode 100644
index 00000000000..75fee706abe
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/statement_analysis.yaml
@@ -0,0 +1,203 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: statement_analysis
+columns:
+ query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ full_scan:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: full_scan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ exec_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: exec_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ err_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: err_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ warn_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: warn_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: lock_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_sent_avg:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_sent_avg
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_examined_avg:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_examined_avg
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_affected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_affected
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_affected_avg:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_affected_avg
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tmp_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: tmp_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ tmp_disk_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: tmp_disk_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_sorted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sorted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sort_merge_passes:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: sort_merge_passes
+ primaryKey: false
+ unsigned: true
+ visible: true
+ digest:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: digest
+ primaryKey: false
+ unsigned: false
+ visible: true
+ first_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: first_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: last_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/statements_with_errors_or_warnings.yaml b/infra/common/src/main/resources/schema/mysql/sys/statements_with_errors_or_warnings.yaml
new file mode 100644
index 00000000000..342a852f5da
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/statements_with_errors_or_warnings.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: statements_with_errors_or_warnings
+columns:
+ query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ exec_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: exec_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: errors
+ primaryKey: false
+ unsigned: true
+ visible: true
+ error_pct:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: error_pct
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warnings:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: warnings
+ primaryKey: false
+ unsigned: true
+ visible: true
+ warning_pct:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: warning_pct
+ primaryKey: false
+ unsigned: false
+ visible: true
+ first_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: first_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: last_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ digest:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: digest
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/statements_with_full_table_scans.yaml b/infra/common/src/main/resources/schema/mysql/sys/statements_with_full_table_scans.yaml
new file mode 100644
index 00000000000..692dc08a8d3
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/statements_with_full_table_scans.yaml
@@ -0,0 +1,131 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: statements_with_full_table_scans
+columns:
+ query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ exec_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: exec_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ no_index_used_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: no_index_used_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ no_good_index_used_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: no_good_index_used_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ no_index_used_pct:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: no_index_used_pct
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_sent_avg:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_sent_avg
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_examined_avg:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_examined_avg
+ primaryKey: false
+ unsigned: true
+ visible: true
+ first_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: first_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: last_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ digest:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: digest
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/statements_with_runtimes_in_95th_percentile.yaml b/infra/common/src/main/resources/schema/mysql/sys/statements_with_runtimes_in_95th_percentile.yaml
new file mode 100644
index 00000000000..1fb2f69e8c4
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/statements_with_runtimes_in_95th_percentile.yaml
@@ -0,0 +1,147 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: statements_with_runtimes_in_95th_percentile
+columns:
+ query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ full_scan:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: full_scan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ exec_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: exec_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ err_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: err_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ warn_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: warn_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_sent_avg:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_sent_avg
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_examined_avg:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_examined_avg
+ primaryKey: false
+ unsigned: false
+ visible: true
+ first_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: first_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: last_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ digest:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: digest
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/statements_with_sorting.yaml b/infra/common/src/main/resources/schema/mysql/sys/statements_with_sorting.yaml
new file mode 100644
index 00000000000..424c1afa9e1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/statements_with_sorting.yaml
@@ -0,0 +1,123 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: statements_with_sorting
+columns:
+ query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ exec_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: exec_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sort_merge_passes:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: sort_merge_passes
+ primaryKey: false
+ unsigned: true
+ visible: true
+ avg_sort_merges:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: avg_sort_merges
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sorts_using_scans:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: sorts_using_scans
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sort_using_range:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: sort_using_range
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_sorted:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sorted
+ primaryKey: false
+ unsigned: true
+ visible: true
+ avg_rows_sorted:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: avg_rows_sorted
+ primaryKey: false
+ unsigned: false
+ visible: true
+ first_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: first_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: last_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ digest:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: digest
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/statements_with_temp_tables.yaml b/infra/common/src/main/resources/schema/mysql/sys/statements_with_temp_tables.yaml
new file mode 100644
index 00000000000..10a91857e14
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/statements_with_temp_tables.yaml
@@ -0,0 +1,107 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: statements_with_temp_tables
+columns:
+ query:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: db
+ primaryKey: false
+ unsigned: false
+ visible: true
+ exec_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: exec_count
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_tmp_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: memory_tmp_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ disk_tmp_tables:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: disk_tmp_tables
+ primaryKey: false
+ unsigned: true
+ visible: true
+ avg_tmp_tables_per_query:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: avg_tmp_tables_per_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tmp_tables_to_disk_pct:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: tmp_tables_to_disk_pct
+ primaryKey: false
+ unsigned: false
+ visible: true
+ first_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: first_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: last_seen
+ primaryKey: false
+ unsigned: false
+ visible: true
+ digest:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: digest
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/user_summary.yaml b/infra/common/src/main/resources/schema/mysql/sys/user_summary.yaml
new file mode 100644
index 00000000000..92207220ec9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/user_summary.yaml
@@ -0,0 +1,115 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_summary
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statements:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: statements
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: statement_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement_avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: statement_avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_scans:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: table_scans
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_ios:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: file_ios
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_io_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: file_io_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_connections:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: current_connections
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_connections:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: total_connections
+ primaryKey: false
+ unsigned: false
+ visible: true
+ unique_hosts:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: unique_hosts
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_memory:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: current_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_memory_allocated:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_memory_allocated
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_file_io.yaml b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_file_io.yaml
new file mode 100644
index 00000000000..8663f266c70
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_file_io.yaml
@@ -0,0 +1,43 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_summary_by_file_io
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ios:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: ios
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: io_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_file_io_type.yaml b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_file_io_type.yaml
new file mode 100644
index 00000000000..38982f6997d
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_file_io_type.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_summary_by_file_io_type
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_stages.yaml b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_stages.yaml
new file mode 100644
index 00000000000..2ad78ef2f20
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_stages.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_summary_by_stages
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_statement_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_statement_latency.yaml
new file mode 100644
index 00000000000..d22848dd554
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_statement_latency.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_summary_by_statement_latency
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: lock_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_affected:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: rows_affected
+ primaryKey: false
+ unsigned: false
+ visible: true
+ full_scans:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: full_scans
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_statement_type.yaml b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_statement_type.yaml
new file mode 100644
index 00000000000..867834d5eee
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/user_summary_by_statement_type.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_summary_by_statement_type
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statement:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: statement
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: lock_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows_sent:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_sent
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_examined:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_examined
+ primaryKey: false
+ unsigned: true
+ visible: true
+ rows_affected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: rows_affected
+ primaryKey: false
+ unsigned: true
+ visible: true
+ full_scans:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: full_scans
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/version.yaml b/infra/common/src/main/resources/schema/mysql/sys/version.yaml
new file mode 100644
index 00000000000..e75e4bb26b2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/version.yaml
@@ -0,0 +1,35 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: version
+columns:
+ sys_version:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: sys_version
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mysql_version:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: mysql_version
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/wait_classes_global_by_avg_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/wait_classes_global_by_avg_latency.yaml
new file mode 100644
index 00000000000..5a7b6e87e6a
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/wait_classes_global_by_avg_latency.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: wait_classes_global_by_avg_latency
+columns:
+ event_class:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_class
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: min_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/wait_classes_global_by_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/wait_classes_global_by_latency.yaml
new file mode 100644
index 00000000000..946b245ba31
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/wait_classes_global_by_latency.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: wait_classes_global_by_latency
+columns:
+ event_class:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event_class
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 3
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: min_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/waits_by_host_by_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/waits_by_host_by_latency.yaml
new file mode 100644
index 00000000000..298e2860368
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/waits_by_host_by_latency.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: waits_by_host_by_latency
+columns:
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: host
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/waits_by_user_by_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/waits_by_user_by_latency.yaml
new file mode 100644
index 00000000000..923ad211367
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/waits_by_user_by_latency.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: waits_by_user_by_latency
+columns:
+ user:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: event
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/sys/waits_global_by_latency.yaml b/infra/common/src/main/resources/schema/mysql/sys/waits_global_by_latency.yaml
new file mode 100644
index 00000000000..ad8bff55412
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/sys/waits_global_by_latency.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: waits_global_by_latency
+columns:
+ events:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: events
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: total
+ primaryKey: false
+ unsigned: true
+ visible: true
+ total_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: total_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: avg_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_latency:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: max_latency
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java
index 98e3ecb54e4..0e9f6c0ca8e 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java
@@ -40,6 +40,9 @@ class SystemSchemaBuilderRuleTest {
SystemSchemaBuilderRule actualPerformanceSchema = SystemSchemaBuilderRule.valueOf(new MySQLDatabaseType().getType(), "performance_schema");
assertThat(actualPerformanceSchema, is(SystemSchemaBuilderRule.MYSQL_PERFORMANCE_SCHEMA));
assertThat(actualPerformanceSchema.getTables().size(), is(87));
+ SystemSchemaBuilderRule actualSysSchema = SystemSchemaBuilderRule.valueOf(new MySQLDatabaseType().getType(), "sys");
+ assertThat(actualSysSchema, is(SystemSchemaBuilderRule.MYSQL_SYS));
+ assertThat(actualSysSchema.getTables().size(), is(53));
SystemSchemaBuilderRule actualPgCatalog = SystemSchemaBuilderRule.valueOf(new PostgreSQLDatabaseType().getType(), "pg_catalog");
assertThat(actualPgCatalog, is(SystemSchemaBuilderRule.POSTGRESQL_PG_CATALOG));
assertThat(actualPgCatalog.getTables().size(), is(134));
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
index 90e6564290c..1eb76a7e9c1 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
@@ -45,6 +45,10 @@ class SystemSchemaBuilderTest {
assertThat(actualPerformanceSchema.size(), is(1));
assertTrue(actualPerformanceSchema.containsKey("performance_schema"));
assertThat(actualPerformanceSchema.get("performance_schema").getTables().size(), is(87));
+ Map<String, ShardingSphereSchema> actualSysSchema = SystemSchemaBuilder.build("sys", new MySQLDatabaseType());
+ assertThat(actualSysSchema.size(), is(1));
+ assertTrue(actualSysSchema.containsKey("sys"));
+ assertThat(actualSysSchema.get("sys").getTables().size(), is(53));
}
@Test
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary.xml
new file mode 100644
index 00000000000..6e4442e20df
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary.xml
@@ -0,0 +1,33 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="statements"/>
+ <column name="statement_latency"/>
+ <column name="statement_avg_latency"/>
+ <column name="table_scans"/>
+ <column name="file_ios"/>
+ <column name="file_io_latency"/>
+ <column name="current_connections"/>
+ <column name="total_connections"/>
+ <column name="unique_users"/>
+ <column name="current_memory"/>
+ <column name="total_memory_allocated"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_file_io.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_file_io.xml
new file mode 100644
index 00000000000..e10f5d12618
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_file_io.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="ios"/>
+ <column name="io_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_file_io_type.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_file_io_type.xml
new file mode 100644
index 00000000000..ca74f996005
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_file_io_type.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="event_name"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="max_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_stages.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_stages.xml
new file mode 100644
index 00000000000..1650b0d7046
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_stages.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="event_name"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="avg_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_statement_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_statement_latency.xml
new file mode 100644
index 00000000000..3e0be588ce7
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_statement_latency.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="max_latency"/>
+ <column name="lock_latency"/>
+ <column name="rows_sent"/>
+ <column name="rows_examined"/>
+ <column name="rows_affected"/>
+ <column name="full_scans"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_statement_type.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_statement_type.xml
new file mode 100644
index 00000000000..63b8898f23a
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_host_summary_by_statement_type.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="statement"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="max_latency"/>
+ <column name="lock_latency"/>
+ <column name="rows_sent"/>
+ <column name="rows_examined"/>
+ <column name="rows_affected"/>
+ <column name="full_scans"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_buffer_stats_by_schema.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_buffer_stats_by_schema.xml
new file mode 100644
index 00000000000..5a289465845
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_buffer_stats_by_schema.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="object_schema"/>
+ <column name="allocated"/>
+ <column name="data"/>
+ <column name="pages"/>
+ <column name="pages_hashed"/>
+ <column name="pages_old"/>
+ <column name="rows_cached"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_buffer_stats_by_table.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_buffer_stats_by_table.xml
new file mode 100644
index 00000000000..56489bf5ecc
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_buffer_stats_by_table.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="object_schema"/>
+ <column name="object_name"/>
+ <column name="allocated"/>
+ <column name="data"/>
+ <column name="pages"/>
+ <column name="pages_hashed"/>
+ <column name="pages_old"/>
+ <column name="rows_cached"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_lock_waits.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_lock_waits.xml
new file mode 100644
index 00000000000..8958979f71c
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_innodb_lock_waits.xml
@@ -0,0 +1,47 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="wait_started"/>
+ <column name="wait_age"/>
+ <column name="wait_age_secs"/>
+ <column name="locked_table"/>
+ <column name="locked_index"/>
+ <column name="locked_type"/>
+ <column name="waiting_trx_id"/>
+ <column name="waiting_trx_started"/>
+ <column name="waiting_trx_age"/>
+ <column name="waiting_trx_rows_locked"/>
+ <column name="waiting_trx_rows_modified"/>
+ <column name="waiting_pid"/>
+ <column name="waiting_query"/>
+ <column name="waiting_lock_id"/>
+ <column name="waiting_lock_mode"/>
+ <column name="blocking_trx_id"/>
+ <column name="blocking_pid"/>
+ <column name="blocking_query"/>
+ <column name="blocking_lock_id"/>
+ <column name="blocking_lock_mode"/>
+ <column name="blocking_trx_started"/>
+ <column name="blocking_trx_age"/>
+ <column name="blocking_trx_rows_locked"/>
+ <column name="blocking_trx_rows_modified"/>
+ <column name="sql_kill_blocking_query"/>
+ <column name="sql_kill_blocking_connection"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_by_thread_by_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_by_thread_by_latency.xml
new file mode 100644
index 00000000000..51d407a3eb9
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_by_thread_by_latency.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="min_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ <column name="thread_id"/>
+ <column name="processlist_id"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_file_by_bytes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_file_by_bytes.xml
new file mode 100644
index 00000000000..0f3f92bf3cd
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_file_by_bytes.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="file"/>
+ <column name="count_read"/>
+ <column name="total_read"/>
+ <column name="avg_read"/>
+ <column name="count_write"/>
+ <column name="total_written"/>
+ <column name="avg_write"/>
+ <column name="total"/>
+ <column name="write_pct"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_file_by_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_file_by_latency.xml
new file mode 100644
index 00000000000..d29b10027a4
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_file_by_latency.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="file"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="count_read"/>
+ <column name="read_latency"/>
+ <column name="count_write"/>
+ <column name="write_latency"/>
+ <column name="count_misc"/>
+ <column name="misc_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_wait_by_bytes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_wait_by_bytes.xml
new file mode 100644
index 00000000000..cc2505cf2c0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_wait_by_bytes.xml
@@ -0,0 +1,34 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="event_name"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="min_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ <column name="count_read"/>
+ <column name="total_read"/>
+ <column name="avg_read"/>
+ <column name="count_write"/>
+ <column name="total_written"/>
+ <column name="avg_written"/>
+ <column name="total_requested"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_wait_by_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_wait_by_latency.xml
new file mode 100644
index 00000000000..a9ef7ac4e12
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_io_global_by_wait_by_latency.xml
@@ -0,0 +1,35 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="event_name"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ <column name="read_latency"/>
+ <column name="write_latency"/>
+ <column name="misc_latency"/>
+ <column name="count_read"/>
+ <column name="total_read"/>
+ <column name="avg_read"/>
+ <column name="count_write"/>
+ <column name="total_written"/>
+ <column name="avg_written"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_latest_file_io.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_latest_file_io.xml
new file mode 100644
index 00000000000..b33f1f5615b
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_latest_file_io.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="thread"/>
+ <column name="file"/>
+ <column name="latency"/>
+ <column name="operation"/>
+ <column name="requested"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_host_by_current_bytes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_host_by_current_bytes.xml
new file mode 100644
index 00000000000..700037c16b4
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_host_by_current_bytes.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="current_count_used"/>
+ <column name="current_allocated"/>
+ <column name="current_avg_alloc"/>
+ <column name="current_max_alloc"/>
+ <column name="total_allocated"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_thread_by_current_bytes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_thread_by_current_bytes.xml
new file mode 100644
index 00000000000..f34a9152128
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_thread_by_current_bytes.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="thread_id"/>
+ <column name="user"/>
+ <column name="current_count_used"/>
+ <column name="current_allocated"/>
+ <column name="current_avg_alloc"/>
+ <column name="current_max_alloc"/>
+ <column name="total_allocated"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_user_by_current_bytes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_user_by_current_bytes.xml
new file mode 100644
index 00000000000..93a13e73836
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_by_user_by_current_bytes.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="current_count_used"/>
+ <column name="current_allocated"/>
+ <column name="current_avg_alloc"/>
+ <column name="current_max_alloc"/>
+ <column name="total_allocated"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_global_by_current_bytes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_global_by_current_bytes.xml
new file mode 100644
index 00000000000..9452d76d6e6
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_global_by_current_bytes.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="event_name"/>
+ <column name="current_count"/>
+ <column name="current_alloc"/>
+ <column name="current_avg_alloc"/>
+ <column name="high_count"/>
+ <column name="high_alloc"/>
+ <column name="high_avg_alloc"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_global_total.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_global_total.xml
new file mode 100644
index 00000000000..0754c9fbb8c
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_memory_global_total.xml
@@ -0,0 +1,22 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="total_allocated"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_metrics.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_metrics.xml
new file mode 100644
index 00000000000..6275447f657
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_metrics.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="variable_name"/>
+ <column name="variable_value"/>
+ <column name="type"/>
+ <column name="enabled"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_processlist.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_processlist.xml
new file mode 100644
index 00000000000..175a8199f10
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_processlist.xml
@@ -0,0 +1,49 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="thd_id"/>
+ <column name="conn_id"/>
+ <column name="user"/>
+ <column name="db"/>
+ <column name="command"/>
+ <column name="state"/>
+ <column name="time"/>
+ <column name="current_statement"/>
+ <column name="statement_latency"/>
+ <column name="progress"/>
+ <column name="lock_latency"/>
+ <column name="rows_examined"/>
+ <column name="rows_sent"/>
+ <column name="rows_affected"/>
+ <column name="tmp_tables"/>
+ <column name="tmp_disk_tables"/>
+ <column name="full_scan"/>
+ <column name="last_statement"/>
+ <column name="last_statement_latency"/>
+ <column name="current_memory"/>
+ <column name="last_wait"/>
+ <column name="last_wait_latency"/>
+ <column name="source"/>
+ <column name="trx_latency"/>
+ <column name="trx_state"/>
+ <column name="trx_autocommit"/>
+ <column name="pid"/>
+ <column name="program_name"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_ps_check_lost_instrumentation.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_ps_check_lost_instrumentation.xml
new file mode 100644
index 00000000000..2124d2e4840
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_ps_check_lost_instrumentation.xml
@@ -0,0 +1,23 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="variable_name"/>
+ <column name="variable_value"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_auto_increment_columns.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_auto_increment_columns.xml
new file mode 100644
index 00000000000..45130ed23ad
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_auto_increment_columns.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_schema"/>
+ <column name="table_name"/>
+ <column name="column_name"/>
+ <column name="data_type"/>
+ <column name="column_type"/>
+ <column name="is_signed"/>
+ <column name="is_unsigned"/>
+ <column name="max_value"/>
+ <column name="auto_increment"/>
+ <column name="auto_increment_ratio"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_index_statistics.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_index_statistics.xml
new file mode 100644
index 00000000000..c7ed2819ee6
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_index_statistics.xml
@@ -0,0 +1,32 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_schema"/>
+ <column name="table_name"/>
+ <column name="index_name"/>
+ <column name="rows_selected"/>
+ <column name="select_latency"/>
+ <column name="rows_inserted"/>
+ <column name="insert_latency"/>
+ <column name="rows_updated"/>
+ <column name="update_latency"/>
+ <column name="rows_deleted"/>
+ <column name="delete_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_object_overview.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_object_overview.xml
new file mode 100644
index 00000000000..29f2d389892
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_object_overview.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="db"/>
+ <column name="object_type"/>
+ <column name="count"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_redundant_indexes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_redundant_indexes.xml
new file mode 100644
index 00000000000..c9c3c90cb33
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_redundant_indexes.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_schema"/>
+ <column name="table_name"/>
+ <column name="redundant_index_name"/>
+ <column name="redundant_index_columns"/>
+ <column name="redundant_index_non_unique"/>
+ <column name="dominant_index_name"/>
+ <column name="dominant_index_columns"/>
+ <column name="dominant_index_non_unique"/>
+ <column name="subpart_exists"/>
+ <column name="sql_drop_index"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_lock_waits.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_lock_waits.xml
new file mode 100644
index 00000000000..e6ee8d635d7
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_lock_waits.xml
@@ -0,0 +1,39 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="object_schema"/>
+ <column name="object_name"/>
+ <column name="waiting_thread_id"/>
+ <column name="waiting_pid"/>
+ <column name="waiting_account"/>
+ <column name="waiting_lock_type"/>
+ <column name="waiting_lock_duration"/>
+ <column name="waiting_query"/>
+ <column name="waiting_query_secs"/>
+ <column name="waiting_query_rows_affected"/>
+ <column name="waiting_query_rows_examined"/>
+ <column name="blocking_thread_id"/>
+ <column name="blocking_pid"/>
+ <column name="blocking_account"/>
+ <column name="blocking_lock_type"/>
+ <column name="blocking_lock_duration"/>
+ <column name="sql_kill_blocking_query"/>
+ <column name="sql_kill_blocking_connection"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_statistics.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_statistics.xml
new file mode 100644
index 00000000000..66bdd72d4c8
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_statistics.xml
@@ -0,0 +1,40 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_schema"/>
+ <column name="table_name"/>
+ <column name="total_latency"/>
+ <column name="rows_fetched"/>
+ <column name="fetch_latency"/>
+ <column name="rows_inserted"/>
+ <column name="insert_latency"/>
+ <column name="rows_updated"/>
+ <column name="update_latency"/>
+ <column name="rows_deleted"/>
+ <column name="delete_latency"/>
+ <column name="io_read_requests"/>
+ <column name="io_read"/>
+ <column name="io_read_latency"/>
+ <column name="io_write_requests"/>
+ <column name="io_write"/>
+ <column name="io_write_latency"/>
+ <column name="io_misc_requests"/>
+ <column name="io_misc_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_statistics_with_buffer.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_statistics_with_buffer.xml
new file mode 100644
index 00000000000..e8585ddb5df
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_table_statistics_with_buffer.xml
@@ -0,0 +1,46 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_schema"/>
+ <column name="table_name"/>
+ <column name="rows_fetched"/>
+ <column name="fetch_latency"/>
+ <column name="rows_inserted"/>
+ <column name="insert_latency"/>
+ <column name="rows_updated"/>
+ <column name="update_latency"/>
+ <column name="rows_deleted"/>
+ <column name="delete_latency"/>
+ <column name="io_read_requests"/>
+ <column name="io_read"/>
+ <column name="io_read_latency"/>
+ <column name="io_write_requests"/>
+ <column name="io_write"/>
+ <column name="io_write_latency"/>
+ <column name="io_misc_requests"/>
+ <column name="io_misc_latency"/>
+ <column name="innodb_buffer_allocated"/>
+ <column name="innodb_buffer_data"/>
+ <column name="innodb_buffer_free"/>
+ <column name="innodb_buffer_pages"/>
+ <column name="innodb_buffer_pages_hashed"/>
+ <column name="innodb_buffer_pages_old"/>
+ <column name="innodb_buffer_rows_cached"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_tables_with_full_table_scans.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_tables_with_full_table_scans.xml
new file mode 100644
index 00000000000..4b789bb6a39
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_tables_with_full_table_scans.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="object_schema"/>
+ <column name="object_name"/>
+ <column name="rows_full_scanned"/>
+ <column name="latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_unused_indexes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_unused_indexes.xml
new file mode 100644
index 00000000000..2440f4a0869
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_schema_unused_indexes.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="object_schema"/>
+ <column name="object_name"/>
+ <column name="index_name"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_session.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_session.xml
new file mode 100644
index 00000000000..175a8199f10
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_session.xml
@@ -0,0 +1,49 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="thd_id"/>
+ <column name="conn_id"/>
+ <column name="user"/>
+ <column name="db"/>
+ <column name="command"/>
+ <column name="state"/>
+ <column name="time"/>
+ <column name="current_statement"/>
+ <column name="statement_latency"/>
+ <column name="progress"/>
+ <column name="lock_latency"/>
+ <column name="rows_examined"/>
+ <column name="rows_sent"/>
+ <column name="rows_affected"/>
+ <column name="tmp_tables"/>
+ <column name="tmp_disk_tables"/>
+ <column name="full_scan"/>
+ <column name="last_statement"/>
+ <column name="last_statement_latency"/>
+ <column name="current_memory"/>
+ <column name="last_wait"/>
+ <column name="last_wait_latency"/>
+ <column name="source"/>
+ <column name="trx_latency"/>
+ <column name="trx_state"/>
+ <column name="trx_autocommit"/>
+ <column name="pid"/>
+ <column name="program_name"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_session_ssl_status.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_session_ssl_status.xml
new file mode 100644
index 00000000000..80ae1279f32
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_session_ssl_status.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="thread_id"/>
+ <column name="ssl_version"/>
+ <column name="ssl_cipher"/>
+ <column name="ssl_sessions_reused"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statement_analysis.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statement_analysis.xml
new file mode 100644
index 00000000000..f1108d82b85
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statement_analysis.xml
@@ -0,0 +1,44 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="query"/>
+ <column name="db"/>
+ <column name="full_scan"/>
+ <column name="exec_count"/>
+ <column name="err_count"/>
+ <column name="warn_count"/>
+ <column name="total_latency"/>
+ <column name="max_latency"/>
+ <column name="avg_latency"/>
+ <column name="lock_latency"/>
+ <column name="rows_sent"/>
+ <column name="rows_sent_avg"/>
+ <column name="rows_examined"/>
+ <column name="rows_examined_avg"/>
+ <column name="rows_affected"/>
+ <column name="rows_affected_avg"/>
+ <column name="tmp_tables"/>
+ <column name="tmp_disk_tables"/>
+ <column name="rows_sorted"/>
+ <column name="sort_merge_passes"/>
+ <column name="digest"/>
+ <column name="first_seen"/>
+ <column name="last_seen"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_errors_or_warnings.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_errors_or_warnings.xml
new file mode 100644
index 00000000000..5c55dee85ae
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_errors_or_warnings.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="query"/>
+ <column name="db"/>
+ <column name="exec_count"/>
+ <column name="errors"/>
+ <column name="error_pct"/>
+ <column name="warnings"/>
+ <column name="warning_pct"/>
+ <column name="first_seen"/>
+ <column name="last_seen"/>
+ <column name="digest"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_full_table_scans.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_full_table_scans.xml
new file mode 100644
index 00000000000..18351c99c78
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_full_table_scans.xml
@@ -0,0 +1,35 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="query"/>
+ <column name="db"/>
+ <column name="exec_count"/>
+ <column name="total_latency"/>
+ <column name="no_index_used_count"/>
+ <column name="no_good_index_used_count"/>
+ <column name="no_index_used_pct"/>
+ <column name="rows_sent"/>
+ <column name="rows_examined"/>
+ <column name="rows_sent_avg"/>
+ <column name="rows_examined_avg"/>
+ <column name="first_seen"/>
+ <column name="last_seen"/>
+ <column name="digest"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_runtimes_in_95th_percentile.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_runtimes_in_95th_percentile.xml
new file mode 100644
index 00000000000..ac54ebab1c4
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_runtimes_in_95th_percentile.xml
@@ -0,0 +1,37 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="query"/>
+ <column name="db"/>
+ <column name="full_scan"/>
+ <column name="exec_count"/>
+ <column name="err_count"/>
+ <column name="warn_count"/>
+ <column name="total_latency"/>
+ <column name="max_latency"/>
+ <column name="avg_latency"/>
+ <column name="rows_sent"/>
+ <column name="rows_sent_avg"/>
+ <column name="rows_examined"/>
+ <column name="rows_examined_avg"/>
+ <column name="first_seen"/>
+ <column name="last_seen"/>
+ <column name="digest"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_sorting.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_sorting.xml
new file mode 100644
index 00000000000..452f2b3c39b
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_sorting.xml
@@ -0,0 +1,34 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="query"/>
+ <column name="db"/>
+ <column name="exec_count"/>
+ <column name="total_latency"/>
+ <column name="sort_merge_passes"/>
+ <column name="avg_sort_merges"/>
+ <column name="sorts_using_scans"/>
+ <column name="sort_using_range"/>
+ <column name="rows_sorted"/>
+ <column name="avg_rows_sorted"/>
+ <column name="first_seen"/>
+ <column name="last_seen"/>
+ <column name="digest"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_temp_tables.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_temp_tables.xml
new file mode 100644
index 00000000000..0a48982b579
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_statements_with_temp_tables.xml
@@ -0,0 +1,32 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="query"/>
+ <column name="db"/>
+ <column name="exec_count"/>
+ <column name="total_latency"/>
+ <column name="memory_tmp_tables"/>
+ <column name="disk_tmp_tables"/>
+ <column name="avg_tmp_tables_per_query"/>
+ <column name="tmp_tables_to_disk_pct"/>
+ <column name="first_seen"/>
+ <column name="last_seen"/>
+ <column name="digest"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_sys_config.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_sys_config.xml
new file mode 100644
index 00000000000..5464be0143c
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_sys_config.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="variable"/>
+ <column name="value"/>
+ <column name="set_time"/>
+ <column name="set_by"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary.xml
new file mode 100644
index 00000000000..54bdec1e72e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary.xml
@@ -0,0 +1,33 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="statements"/>
+ <column name="statement_latency"/>
+ <column name="statement_avg_latency"/>
+ <column name="table_scans"/>
+ <column name="file_ios"/>
+ <column name="file_io_latency"/>
+ <column name="current_connections"/>
+ <column name="total_connections"/>
+ <column name="unique_hosts"/>
+ <column name="current_memory"/>
+ <column name="total_memory_allocated"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_file_io.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_file_io.xml
new file mode 100644
index 00000000000..5c10e9d9ed3
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_file_io.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="ios"/>
+ <column name="io_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_file_io_type.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_file_io_type.xml
new file mode 100644
index 00000000000..c95e23a82e0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_file_io_type.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="event_name"/>
+ <column name="total"/>
+ <column name="latency"/>
+ <column name="max_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_stages.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_stages.xml
new file mode 100644
index 00000000000..5afa3c161c7
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_stages.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="event_name"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="avg_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_statement_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_statement_latency.xml
new file mode 100644
index 00000000000..f4bf5d47b23
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_statement_latency.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="max_latency"/>
+ <column name="lock_latency"/>
+ <column name="rows_sent"/>
+ <column name="rows_examined"/>
+ <column name="rows_affected"/>
+ <column name="full_scans"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_statement_type.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_statement_type.xml
new file mode 100644
index 00000000000..2e62715a44e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_user_summary_by_statement_type.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="statement"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="max_latency"/>
+ <column name="lock_latency"/>
+ <column name="rows_sent"/>
+ <column name="rows_examined"/>
+ <column name="rows_affected"/>
+ <column name="full_scans"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_version.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_version.xml
new file mode 100644
index 00000000000..4143ba0526a
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_version.xml
@@ -0,0 +1,23 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sys_version"/>
+ <column name="mysql_version"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_wait_classes_global_by_avg_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_wait_classes_global_by_avg_latency.xml
new file mode 100644
index 00000000000..f73a5ad0b29
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_wait_classes_global_by_avg_latency.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="event_class"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="min_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_wait_classes_global_by_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_wait_classes_global_by_latency.xml
new file mode 100644
index 00000000000..f73a5ad0b29
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_wait_classes_global_by_latency.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="event_class"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="min_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_by_host_by_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_by_host_by_latency.xml
new file mode 100644
index 00000000000..c1283b5bd12
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_by_host_by_latency.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="host"/>
+ <column name="event"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_by_user_by_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_by_user_by_latency.xml
new file mode 100644
index 00000000000..3c8029a319c
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_by_user_by_latency.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user"/>
+ <column name="event"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_global_by_latency.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_global_by_latency.xml
new file mode 100644
index 00000000000..01698906b9d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_sys_waits_global_by_latency.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="events"/>
+ <column name="total"/>
+ <column name="total_latency"/>
+ <column name="avg_latency"/>
+ <column name="max_latency"/>
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
index 53135d95e21..124caada46d 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
@@ -781,4 +781,217 @@
<test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_cluster" db-types="PostgreSQL" scenario-types="db">
<assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_progress_cluster.xml" />
</test-case>
+
+ <test-case sql="SELECT * FROM sys.host_summary" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_host_summary.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.host_summary_by_file_io" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_host_summary_by_file_io.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.host_summary_by_file_io_type" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_host_summary_by_file_io_type.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.host_summary_by_stages" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_host_summary_by_stages.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.host_summary_by_statement_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_host_summary_by_statement_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.host_summary_by_statement_type" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_host_summary_by_statement_type.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.innodb_buffer_stats_by_schema" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_innodb_buffer_stats_by_schema.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.innodb_buffer_stats_by_table" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_innodb_buffer_stats_by_table.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.innodb_lock_waits" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_innodb_lock_waits.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.io_by_thread_by_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_io_by_thread_by_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.io_global_by_file_by_bytes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_io_global_by_file_by_bytes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.io_global_by_file_by_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_io_global_by_file_by_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.io_global_by_wait_by_bytes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_io_global_by_wait_by_bytes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.io_global_by_wait_by_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_io_global_by_wait_by_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.latest_file_io" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_latest_file_io.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.memory_by_host_by_current_bytes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_memory_by_host_by_current_bytes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.memory_by_thread_by_current_bytes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_memory_by_thread_by_current_bytes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.memory_by_user_by_current_bytes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_memory_by_user_by_current_bytes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.memory_global_by_current_bytes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_memory_global_by_current_bytes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.memory_global_total" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_memory_global_total.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.metrics" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_metrics.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.processlist" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_processlist.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.ps_check_lost_instrumentation" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_ps_check_lost_instrumentation.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_auto_increment_columns" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_auto_increment_columns.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_index_statistics" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_index_statistics.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_object_overview" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_object_overview.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_redundant_indexes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_redundant_indexes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_table_lock_waits" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_table_lock_waits.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_table_statistics" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_table_statistics.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_table_statistics_with_buffer" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_table_statistics_with_buffer.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_tables_with_full_table_scans" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_tables_with_full_table_scans.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.schema_unused_indexes" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_schema_unused_indexes.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.session" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_session.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.session_ssl_status" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_session_ssl_status.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.statement_analysis" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_statement_analysis.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.statements_with_errors_or_warnings" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_statements_with_errors_or_warnings.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.statements_with_full_table_scans" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_statements_with_full_table_scans.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.statements_with_runtimes_in_95th_percentile" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_statements_with_runtimes_in_95th_percentile.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.statements_with_sorting" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_statements_with_sorting.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.statements_with_temp_tables" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_statements_with_temp_tables.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.sys_config" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_sys_config.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.user_summary" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_user_summary.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.user_summary_by_file_io" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_user_summary_by_file_io.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.user_summary_by_file_io_type" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_user_summary_by_file_io_type.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.user_summary_by_stages" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_user_summary_by_stages.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.user_summary_by_statement_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_user_summary_by_statement_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.user_summary_by_statement_type" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_user_summary_by_statement_type.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.version" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_version.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.wait_classes_global_by_avg_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_wait_classes_global_by_avg_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.wait_classes_global_by_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_wait_classes_global_by_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.waits_by_host_by_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_waits_by_host_by_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.waits_by_user_by_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_waits_by_user_by_latency.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM sys.waits_global_by_latency" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_sys_waits_global_by_latency.xml" />
+ </test-case>
+
</integration-test-cases>