You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by tu...@apache.org on 2023/04/21 10:19:16 UTC
[shardingsphere] branch master updated: Add more mysql performance schema tables (#25256)
This is an automated email from the ASF dual-hosted git repository.
tuichenchuxin 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 5a5e52bb411 Add more mysql performance schema tables (#25256)
5a5e52bb411 is described below
commit 5a5e52bb411ca63ed3aa8054fdb325c042911a1e
Author: ZhangCheng <fl...@outlook.com>
AuthorDate: Fri Apr 21 18:18:58 2023 +0800
Add more mysql performance schema tables (#25256)
---
.../schema/builder/SystemSchemaBuilderRule.java | 4 +-
.../mysql/performance_schema/global_status.yaml | 35 +++
.../mysql/performance_schema/global_variables.yaml | 35 +++
.../mysql/performance_schema/host_cache.yaml | 251 +++++++++++++++++++++
.../schema/mysql/performance_schema/hosts.yaml | 43 ++++
.../memory_summary_by_account_by_event_name.yaml | 123 ++++++++++
.../memory_summary_by_host_by_event_name.yaml | 115 ++++++++++
.../memory_summary_by_thread_by_event_name.yaml | 115 ++++++++++
.../memory_summary_by_user_by_event_name.yaml | 115 ++++++++++
.../memory_summary_global_by_event_name.yaml | 107 +++++++++
.../mysql/performance_schema/metadata_locks.yaml | 99 ++++++++
.../builder/SystemSchemaBuilderRuleTest.java | 2 +-
.../schema/builder/SystemSchemaBuilderTest.java | 2 +-
...lect_mysql_performance_schema_global_status.xml | 23 ++
...t_mysql_performance_schema_global_variables.xml | 23 ++
.../select_mysql_performance_schema_host_cache.xml | 50 ++++
.../db/select_mysql_performance_schema_hosts.xml | 24 ++
...ema_memory_summary_by_account_by_event_name.xml | 34 +++
...schema_memory_summary_by_host_by_event_name.xml | 33 +++
...hema_memory_summary_by_thread_by_event_name.xml | 33 +++
...schema_memory_summary_by_user_by_event_name.xml | 33 +++
..._schema_memory_summary_global_by_event_name.xml | 32 +++
...ect_mysql_performance_schema_metadata_locks.xml | 31 +++
.../dql/dql-integration-select-system-schema.xml | 40 ++++
24 files changed, 1399 insertions(+), 3 deletions(-)
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 8a740699631..adcb4c204d5 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
@@ -61,7 +61,9 @@ public enum SystemSchemaBuilderRule {
"events_transactions_summary_by_host_by_event_name", "events_transactions_summary_by_thread_by_event_name", "events_transactions_summary_by_user_by_event_name",
"events_transactions_summary_global_by_event_name", "events_waits_current", "events_waits_history", "events_waits_history_long", "events_waits_summary_by_account_by_event_name",
"events_waits_summary_by_host_by_event_name", "events_waits_summary_by_instance", "events_waits_summary_by_thread_by_event_name", "events_waits_summary_by_user_by_event_name",
- "events_waits_summary_global_by_event_name", "file_instances", "file_summary_by_event_name", "file_summary_by_instance"))),
+ "events_waits_summary_global_by_event_name", "file_instances", "file_summary_by_event_name", "file_summary_by_instance", "global_status", "global_variables", "host_cache", "hosts",
+ "memory_summary_by_account_by_event_name", "memory_summary_by_host_by_event_name", "memory_summary_by_thread_by_event_name", "memory_summary_by_user_by_event_name",
+ "memory_summary_global_by_event_name", "metadata_locks"))),
MYSQL_SYS("MySQL", "sys", new HashSet<>(Collections.singleton("sys"))),
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/global_status.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/global_status.yaml
new file mode 100644
index 00000000000..26725e3a732
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/global_status.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: global_status
+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/performance_schema/global_variables.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/global_variables.yaml
new file mode 100644
index 00000000000..b74ddbfa039
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/global_variables.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: global_variables
+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/performance_schema/host_cache.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/host_cache.yaml
new file mode 100644
index 00000000000..2b13926e4aa
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/host_cache.yaml
@@ -0,0 +1,251 @@
+#
+# 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_cache
+columns:
+ ip:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: IP
+ primaryKey: false
+ unsigned: false
+ visible: true
+ host:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: HOST
+ primaryKey: false
+ unsigned: false
+ visible: true
+ host_validated:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: HOST_VALIDATED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sum_connect_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_CONNECT_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_host_blocked_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_HOST_BLOCKED_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_nameinfo_transient_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_NAMEINFO_TRANSIENT_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_nameinfo_permanent_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_NAMEINFO_PERMANENT_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_format_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_FORMAT_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_addrinfo_transient_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_ADDRINFO_TRANSIENT_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_addrinfo_permanent_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_ADDRINFO_PERMANENT_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_fcrdns_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_FCRDNS_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_host_acl_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_HOST_ACL_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_no_auth_plugin_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_NO_AUTH_PLUGIN_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_auth_plugin_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_AUTH_PLUGIN_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_handshake_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_HANDSHAKE_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_proxy_user_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_PROXY_USER_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_proxy_user_acl_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_PROXY_USER_ACL_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_authentication_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_AUTHENTICATION_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_ssl_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_SSL_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_max_user_connections_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_MAX_USER_CONNECTIONS_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_max_user_connections_per_hour_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_default_database_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_DEFAULT_DATABASE_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_init_connect_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_INIT_CONNECT_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_local_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_LOCAL_ERRORS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_unknown_errors:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_UNKNOWN_ERRORS
+ 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
+ first_error_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: FIRST_ERROR_SEEN
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_error_seen:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: LAST_ERROR_SEEN
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/hosts.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/hosts.yaml
new file mode 100644
index 00000000000..f7867f7b500
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/hosts.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: hosts
+columns:
+ host:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: HOST
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_connections:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_CONNECTIONS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_connections:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TOTAL_CONNECTIONS
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_account_by_event_name.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_account_by_event_name.yaml
new file mode 100644
index 00000000000..b45c3de930a
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_account_by_event_name.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: memory_summary_by_account_by_event_name
+columns:
+ user:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: USER
+ primaryKey: false
+ unsigned: false
+ visible: true
+ host:
+ caseSensitive: true
+ dataType: 1
+ 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
+ count_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ low_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ low_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_host_by_event_name.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_host_by_event_name.yaml
new file mode 100644
index 00000000000..f09cf10ce65
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_host_by_event_name.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: memory_summary_by_host_by_event_name
+columns:
+ host:
+ caseSensitive: true
+ dataType: 1
+ 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
+ count_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ low_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ low_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_thread_by_event_name.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_thread_by_event_name.yaml
new file mode 100644
index 00000000000..b536c629f1a
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_thread_by_event_name.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: memory_summary_by_thread_by_event_name
+columns:
+ thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: THREAD_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: EVENT_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ low_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ low_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_user_by_event_name.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_user_by_event_name.yaml
new file mode 100644
index 00000000000..30e1374e775
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_by_user_by_event_name.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: memory_summary_by_user_by_event_name
+columns:
+ user:
+ caseSensitive: true
+ dataType: 1
+ 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
+ count_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ low_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ low_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_global_by_event_name.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_global_by_event_name.yaml
new file mode 100644
index 00000000000..81ad86358e2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/memory_summary_global_by_event_name.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: memory_summary_global_by_event_name
+columns:
+ event_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: EVENT_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_alloc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_ALLOC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ sum_number_of_bytes_free:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SUM_NUMBER_OF_BYTES_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ low_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_count_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_COUNT_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ low_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: LOW_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ current_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CURRENT_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ high_number_of_bytes_used:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: HIGH_NUMBER_OF_BYTES_USED
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/metadata_locks.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/metadata_locks.yaml
new file mode 100644
index 00000000000..2b724bd52cb
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/metadata_locks.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: metadata_locks
+columns:
+ object_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: OBJECT_TYPE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ 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
+ object_instance_begin:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: OBJECT_INSTANCE_BEGIN
+ primaryKey: false
+ unsigned: true
+ visible: true
+ lock_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: LOCK_TYPE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_duration:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: LOCK_DURATION
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lock_status:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: LOCK_STATUS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ source:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: SOURCE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ owner_thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: OWNER_THREAD_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ owner_event_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: OWNER_EVENT_ID
+ primaryKey: false
+ unsigned: true
+ 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 6dc0e89621c..59eed2c29d0 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
@@ -38,7 +38,7 @@ class SystemSchemaBuilderRuleTest {
assertThat(actualMySQLSchema.getTables().size(), is(31));
SystemSchemaBuilderRule actualPerformanceSchema = SystemSchemaBuilderRule.valueOf(new MySQLDatabaseType().getType(), "performance_schema");
assertThat(actualPerformanceSchema, is(SystemSchemaBuilderRule.MYSQL_PERFORMANCE_SCHEMA));
- assertThat(actualPerformanceSchema.getTables().size(), is(39));
+ assertThat(actualPerformanceSchema.getTables().size(), is(49));
}
@Test
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 a9a9eb98ca2..1066ae3448b 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
@@ -44,7 +44,7 @@ class SystemSchemaBuilderTest {
Map<String, ShardingSphereSchema> actualPerformanceSchema = SystemSchemaBuilder.build("performance_schema", new MySQLDatabaseType());
assertThat(actualPerformanceSchema.size(), is(1));
assertTrue(actualPerformanceSchema.containsKey("performance_schema"));
- assertThat(actualPerformanceSchema.get("performance_schema").getTables().size(), is(39));
+ assertThat(actualPerformanceSchema.get("performance_schema").getTables().size(), is(49));
}
@Test
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_global_status.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_global_status.xml
new file mode 100644
index 00000000000..f8eee419e82
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_global_status.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_performance_schema_global_variables.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_global_variables.xml
new file mode 100644
index 00000000000..f8eee419e82
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_global_variables.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_performance_schema_host_cache.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_host_cache.xml
new file mode 100644
index 00000000000..c095ac263e3
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_host_cache.xml
@@ -0,0 +1,50 @@
+<!--
+ ~ 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="ip" />
+ <column name="host" />
+ <column name="host_validated" />
+ <column name="sum_connect_errors" />
+ <column name="count_host_blocked_errors" />
+ <column name="count_nameinfo_transient_errors" />
+ <column name="count_nameinfo_permanent_errors" />
+ <column name="count_format_errors" />
+ <column name="count_addrinfo_transient_errors" />
+ <column name="count_addrinfo_permanent_errors" />
+ <column name="count_fcrdns_errors" />
+ <column name="count_host_acl_errors" />
+ <column name="count_no_auth_plugin_errors" />
+ <column name="count_auth_plugin_errors" />
+ <column name="count_handshake_errors" />
+ <column name="count_proxy_user_errors" />
+ <column name="count_proxy_user_acl_errors" />
+ <column name="count_authentication_errors" />
+ <column name="count_ssl_errors" />
+ <column name="count_max_user_connections_errors" />
+ <column name="count_max_user_connections_per_hour_errors" />
+ <column name="count_default_database_errors" />
+ <column name="count_init_connect_errors" />
+ <column name="count_local_errors" />
+ <column name="count_unknown_errors" />
+ <column name="first_seen" />
+ <column name="last_seen" />
+ <column name="first_error_seen" />
+ <column name="last_error_seen" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_hosts.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_hosts.xml
new file mode 100644
index 00000000000..6d57ff964f0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_hosts.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="current_connections" />
+ <column name="total_connections" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_account_by_event_name.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_account_by_event_name.xml
new file mode 100644
index 00000000000..77e7076b826
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_account_by_event_name.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="user" />
+ <column name="host" />
+ <column name="event_name" />
+ <column name="count_alloc" />
+ <column name="count_free" />
+ <column name="sum_number_of_bytes_alloc" />
+ <column name="sum_number_of_bytes_free" />
+ <column name="low_count_used" />
+ <column name="current_count_used" />
+ <column name="high_count_used" />
+ <column name="low_number_of_bytes_used" />
+ <column name="current_number_of_bytes_used" />
+ <column name="high_number_of_bytes_used" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_host_by_event_name.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_host_by_event_name.xml
new file mode 100644
index 00000000000..1dac258180d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_host_by_event_name.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="event_name" />
+ <column name="count_alloc" />
+ <column name="count_free" />
+ <column name="sum_number_of_bytes_alloc" />
+ <column name="sum_number_of_bytes_free" />
+ <column name="low_count_used" />
+ <column name="current_count_used" />
+ <column name="high_count_used" />
+ <column name="low_number_of_bytes_used" />
+ <column name="current_number_of_bytes_used" />
+ <column name="high_number_of_bytes_used" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_thread_by_event_name.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_thread_by_event_name.xml
new file mode 100644
index 00000000000..79b4330bdd1
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_thread_by_event_name.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="thread_id" />
+ <column name="event_name" />
+ <column name="count_alloc" />
+ <column name="count_free" />
+ <column name="sum_number_of_bytes_alloc" />
+ <column name="sum_number_of_bytes_free" />
+ <column name="low_count_used" />
+ <column name="current_count_used" />
+ <column name="high_count_used" />
+ <column name="low_number_of_bytes_used" />
+ <column name="current_number_of_bytes_used" />
+ <column name="high_number_of_bytes_used" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_user_by_event_name.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_user_by_event_name.xml
new file mode 100644
index 00000000000..4ffcbd64e4e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_by_user_by_event_name.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="event_name" />
+ <column name="count_alloc" />
+ <column name="count_free" />
+ <column name="sum_number_of_bytes_alloc" />
+ <column name="sum_number_of_bytes_free" />
+ <column name="low_count_used" />
+ <column name="current_count_used" />
+ <column name="high_count_used" />
+ <column name="low_number_of_bytes_used" />
+ <column name="current_number_of_bytes_used" />
+ <column name="high_number_of_bytes_used" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_global_by_event_name.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_global_by_event_name.xml
new file mode 100644
index 00000000000..e1311b330d8
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_memory_summary_global_by_event_name.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="event_name" />
+ <column name="count_alloc" />
+ <column name="count_free" />
+ <column name="sum_number_of_bytes_alloc" />
+ <column name="sum_number_of_bytes_free" />
+ <column name="low_count_used" />
+ <column name="current_count_used" />
+ <column name="high_count_used" />
+ <column name="low_number_of_bytes_used" />
+ <column name="current_number_of_bytes_used" />
+ <column name="high_number_of_bytes_used" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_metadata_locks.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_metadata_locks.xml
new file mode 100644
index 00000000000..214f8b03659
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_metadata_locks.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="object_type" />
+ <column name="object_schema" />
+ <column name="object_name" />
+ <column name="object_instance_begin" />
+ <column name="lock_type" />
+ <column name="lock_duration" />
+ <column name="lock_status" />
+ <column name="source" />
+ <column name="owner_thread_id" />
+ <column name="owner_event_id" />
+ </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 e273ab6384c..75bce6dc2d1 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
@@ -528,4 +528,44 @@
<test-case sql="SELECT * FROM performance_schema.file_summary_by_instance" db-types="MySQL" scenario-types="db">
<assertion expected-data-file="select_mysql_performance_schema_file_summary_by_instance.xml" />
</test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.global_status" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_global_status.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.global_variables" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_global_variables.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.host_cache" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_host_cache.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.hosts" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_hosts.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_account_by_event_name" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_account_by_event_name.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_host_by_event_name" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_host_by_event_name.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_thread_by_event_name" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_thread_by_event_name.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_user_by_event_name" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_user_by_event_name.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_global_by_event_name" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_memory_summary_global_by_event_name.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.metadata_locks" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_metadata_locks.xml" />
+ </test-case>
</integration-test-cases>