summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result')
-rw-r--r--mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result b/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result
index 9cd668c8e7a..455b6a2ad00 100644
--- a/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result
+++ b/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result
@@ -1,6 +1,7 @@
#==============================================================================
# Establish the level of IPV6 support
#==============================================================================
+connection default;
#==============================================================================
# Get hostname, port number
#==============================================================================
@@ -12,6 +13,7 @@ SELECT @@port INTO @MY_MASTER_PORT;
# 1.1 Disable instrumentation of the default (this) connection
+connection default;
UPDATE performance_schema.threads
SET INSTRUMENTED='NO' WHERE PROCESSLIST_ID = CONNECTION_ID();
@@ -74,23 +76,27 @@ TRUNCATE performance_schema.socket_summary_by_event_name;
for later comparison to the 'after' byte count as a simple confirmation
that the table was updated.
+connection default;
SELECT sum(SUM_NUMBER_OF_BYTES_WRITE) INTO @my_write_count
FROM performance_schema.socket_summary_by_instance;
# 3.3 From connection 1, insert one a 1K row of data into t1
+connection con1;
USE mysqltest;
INSERT INTO t1 (s1) VALUES (REPEAT('a', 1024));
INSERT INTO t1 (s1) SELECT s1 FROM t1;
# 3.4 From connection 2, insert one a 1K row of data into t2
+connection con2;
USE mysqltest;
INSERT INTO t2 (s1) VALUES (REPEAT('a', 1024));
INSERT INTO t2 (s1) SELECT s1 FROM t2;
# 3.5 Get the 'after' sum of bytes written from socket_summary_by_instance
+connection default;
SELECT sum(SUM_NUMBER_OF_BYTES_WRITE) INTO @my_write_count
FROM performance_schema.socket_summary_by_instance;
@@ -112,10 +118,15 @@ consistent with totals in socket_summary_by_instance
# 5.1 Disconnect con1
+connection con1;
+disconnect con1;
# 5.2 Disconnect con2
+connection con2;
+disconnect con2;
# 5.3 Drop mysqltest
+connection default;
DROP DATABASE mysqltest;