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/04/24 01:12:15 UTC
[shardingsphere] branch master updated: Add more mysql performance_schema tables (#25282)
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 24b24550343 Add more mysql performance_schema tables (#25282)
24b24550343 is described below
commit 24b24550343957864619a85185b03b4391b065a7
Author: ZhangCheng <fl...@outlook.com>
AuthorDate: Mon Apr 24 09:12:07 2023 +0800
Add more mysql performance_schema tables (#25282)
* Add more mysql performance_schema tables
* fix
---
.../schema/builder/SystemSchemaBuilderRule.java | 3 +-
.../replication_group_member_stats.yaml | 91 ++++++++++++++++++++++
.../replication_group_members.yaml | 59 ++++++++++++++
.../mysql/performance_schema/rwlock_instances.yaml | 51 ++++++++++++
.../session_account_connect_attrs.yaml | 51 ++++++++++++
.../performance_schema/session_connect_attrs.yaml | 51 ++++++++++++
.../mysql/performance_schema/session_status.yaml | 35 +++++++++
.../performance_schema/session_variables.yaml | 35 +++++++++
.../mysql/performance_schema/setup_actors.yaml | 59 ++++++++++++++
.../mysql/performance_schema/setup_consumers.yaml | 35 +++++++++
.../performance_schema/setup_instruments.yaml | 43 ++++++++++
.../builder/SystemSchemaBuilderRuleTest.java | 2 +-
.../schema/builder/SystemSchemaBuilderTest.java | 2 +-
...mance_schema_replication_group_member_stats.xml | 30 +++++++
...erformance_schema_replication_group_members.xml | 26 +++++++
...t_mysql_performance_schema_rwlock_instances.xml | 25 ++++++
...rmance_schema_session_account_connect_attrs.xml | 25 ++++++
...ql_performance_schema_session_connect_attrs.xml | 25 ++++++
...ect_mysql_performance_schema_session_status.xml | 23 ++++++
..._mysql_performance_schema_session_variables.xml | 23 ++++++
...elect_mysql_performance_schema_setup_actors.xml | 26 +++++++
...ct_mysql_performance_schema_setup_consumers.xml | 23 ++++++
..._mysql_performance_schema_setup_instruments.xml | 24 ++++++
.../dql/dql-integration-select-system-schema.xml | 40 ++++++++++
24 files changed, 804 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 ba21d101421..5fdbde7ddea 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
@@ -65,7 +65,8 @@ public enum SystemSchemaBuilderRule {
"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", "mutex_instances", "objects_summary_global_by_type", "performance_timers", "prepared_statements_instances",
"replication_applier_configuration", "replication_applier_status", "replication_applier_status_by_coordinator", "replication_applier_status_by_worker",
- "replication_connection_configuration", "replication_connection_status"))),
+ "replication_connection_configuration", "replication_connection_status", "replication_group_member_stats", "replication_group_members", "rwlock_instances", "session_account_connect_attrs",
+ "session_connect_attrs", "session_status", "session_variables", "setup_actors", "setup_consumers", "setup_instruments"))),
MYSQL_SYS("MySQL", "sys", new HashSet<>(Collections.singleton("sys"))),
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/replication_group_member_stats.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/replication_group_member_stats.yaml
new file mode 100644
index 00000000000..6ab6683eaca
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/replication_group_member_stats.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: replication_group_member_stats
+columns:
+ channel_name:
+ caseSensitive: false
+ dataType: 1
+ generated: false
+ name: CHANNEL_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ view_id:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: VIEW_ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ member_id:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: MEMBER_ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ count_transactions_in_queue:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_TRANSACTIONS_IN_QUEUE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_transactions_checked:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_TRANSACTIONS_CHECKED
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_conflicts_detected:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_CONFLICTS_DETECTED
+ primaryKey: false
+ unsigned: true
+ visible: true
+ count_transactions_rows_validating:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: COUNT_TRANSACTIONS_ROWS_VALIDATING
+ primaryKey: false
+ unsigned: true
+ visible: true
+ transactions_committed_all_members:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: TRANSACTIONS_COMMITTED_ALL_MEMBERS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_conflict_free_transaction:
+ caseSensitive: false
+ dataType: -1
+ generated: false
+ name: LAST_CONFLICT_FREE_TRANSACTION
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/replication_group_members.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/replication_group_members.yaml
new file mode 100644
index 00000000000..0b784066408
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/replication_group_members.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: replication_group_members
+columns:
+ channel_name:
+ caseSensitive: false
+ dataType: 1
+ generated: false
+ name: CHANNEL_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ member_id:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: MEMBER_ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ member_host:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: MEMBER_HOST
+ primaryKey: false
+ unsigned: false
+ visible: true
+ member_port:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: MEMBER_PORT
+ primaryKey: false
+ unsigned: false
+ visible: true
+ member_state:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: MEMBER_STATE
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/rwlock_instances.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/rwlock_instances.yaml
new file mode 100644
index 00000000000..2e97f96c874
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/rwlock_instances.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: rwlock_instances
+columns:
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: 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
+ write_locked_by_thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: WRITE_LOCKED_BY_THREAD_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ read_locked_by_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: READ_LOCKED_BY_COUNT
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/session_account_connect_attrs.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/session_account_connect_attrs.yaml
new file mode 100644
index 00000000000..e8eec19d1f7
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/session_account_connect_attrs.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_account_connect_attrs
+columns:
+ processlist_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: PROCESSLIST_ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attr_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ATTR_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attr_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ATTR_VALUE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordinal_position:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: ORDINAL_POSITION
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/session_connect_attrs.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/session_connect_attrs.yaml
new file mode 100644
index 00000000000..5b87669f577
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/session_connect_attrs.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_connect_attrs
+columns:
+ processlist_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: PROCESSLIST_ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attr_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ATTR_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attr_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ATTR_VALUE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordinal_position:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: ORDINAL_POSITION
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/session_status.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/session_status.yaml
new file mode 100644
index 00000000000..c3b7411dcc7
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/session_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: session_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/session_variables.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/session_variables.yaml
new file mode 100644
index 00000000000..68f651aea4e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/session_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: session_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/setup_actors.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/setup_actors.yaml
new file mode 100644
index 00000000000..ccc407580ff
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/setup_actors.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: setup_actors
+columns:
+ host:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: HOST
+ primaryKey: false
+ unsigned: false
+ visible: true
+ user:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: USER
+ primaryKey: false
+ unsigned: false
+ visible: true
+ role:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: ROLE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ enabled:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ENABLED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ history:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: HISTORY
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/performance_schema/setup_consumers.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/setup_consumers.yaml
new file mode 100644
index 00000000000..c071bcd1e86
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/setup_consumers.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: setup_consumers
+columns:
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ 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/performance_schema/setup_instruments.yaml b/infra/common/src/main/resources/schema/mysql/performance_schema/setup_instruments.yaml
new file mode 100644
index 00000000000..9d167281db4
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/performance_schema/setup_instruments.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: setup_instruments
+columns:
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ enabled:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ENABLED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ timed:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: TIMED
+ 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 75de584be23..e178250e5fa 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(59));
+ assertThat(actualPerformanceSchema.getTables().size(), is(69));
}
@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 815ce0cd89c..b5456b482dc 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(59));
+ assertThat(actualPerformanceSchema.get("performance_schema").getTables().size(), is(69));
}
@Test
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_replication_group_member_stats.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_replication_group_member_stats.xml
new file mode 100644
index 00000000000..609745d8c5f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_replication_group_member_stats.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="channel_name" />
+ <column name="view_id" />
+ <column name="member_id" />
+ <column name="count_transactions_in_queue" />
+ <column name="count_transactions_checked" />
+ <column name="count_conflicts_detected" />
+ <column name="count_transactions_rows_validating" />
+ <column name="transactions_committed_all_members" />
+ <column name="last_conflict_free_transaction" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_replication_group_members.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_replication_group_members.xml
new file mode 100644
index 00000000000..08f4392177f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_replication_group_members.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="channel_name" />
+ <column name="member_id" />
+ <column name="member_host" />
+ <column name="member_port" />
+ <column name="member_state" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_rwlock_instances.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_rwlock_instances.xml
new file mode 100644
index 00000000000..eefc1b556b9
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_rwlock_instances.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="name" />
+ <column name="object_instance_begin" />
+ <column name="write_locked_by_thread_id" />
+ <column name="read_locked_by_count" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_account_connect_attrs.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_account_connect_attrs.xml
new file mode 100644
index 00000000000..18e9417ad0f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_account_connect_attrs.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="processlist_id" />
+ <column name="attr_name" />
+ <column name="attr_value" />
+ <column name="ordinal_position" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_connect_attrs.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_connect_attrs.xml
new file mode 100644
index 00000000000..18e9417ad0f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_connect_attrs.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="processlist_id" />
+ <column name="attr_name" />
+ <column name="attr_value" />
+ <column name="ordinal_position" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_status.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_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_session_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_session_variables.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_session_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_session_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_setup_actors.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_actors.xml
new file mode 100644
index 00000000000..8d65e32ae41
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_actors.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="user" />
+ <column name="role" />
+ <column name="enabled" />
+ <column name="history" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_consumers.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_consumers.xml
new file mode 100644
index 00000000000..f38cbcd7140
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_consumers.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="name" />
+ <column name="enabled" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_instruments.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_instruments.xml
new file mode 100644
index 00000000000..2c92e678d5e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_performance_schema_setup_instruments.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="name" />
+ <column name="enabled" />
+ <column name="timed" />
+ </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 a1a53ba96d2..0d55ab268f0 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
@@ -608,4 +608,44 @@
<test-case sql="SELECT * FROM performance_schema.replication_connection_status" db-types="MySQL" scenario-types="db">
<assertion expected-data-file="select_mysql_performance_schema_replication_connection_status.xml" />
</test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.replication_group_member_stats" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_replication_group_member_stats.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.replication_group_members" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_replication_group_members.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.rwlock_instances" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_rwlock_instances.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.session_account_connect_attrs" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_session_account_connect_attrs.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.session_connect_attrs" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_session_connect_attrs.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.session_status" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_session_status.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.session_variables" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_session_variables.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.setup_actors" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_setup_actors.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.setup_consumers" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_setup_consumers.xml" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM performance_schema.setup_instruments" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_performance_schema_setup_instruments.xml" />
+ </test-case>
</integration-test-cases>