[MDEV-19413] perfschema.socket_summary_by_instance_func failed in buildbot with wrong result - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Won't Fix
Affects Version/s: 10.2
Fix Version/s: N/A
Component/s: Tests
Labels:
None

Description

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/5993

10.2 b718ec05
perfschema.socket_summary_by_instance_func w3 [ fail ]
Test ended at 2019-04-03 18:38:44

CURRENT_TEST: perfschema.socket_summary_by_instance_func
--- /usr/share/mysql/mysql-test/suite/perfschema/r/socket_summary_by_instance_func.result 2019-04-03 14:45:59.000000000 -0400
+++ /dev/shm/var/3/log/socket_summary_by_instance_func.reject 2019-04-03 18:38:44.696000000 -0400
@@ -28,6 +28,53 @@
# 2.3 Connect should pass, host = localhost
# length of user name = 4 character
# length of default db = 9 character
+# The statistics looks suspicious.
+# We expect
+# COUNT_STAR * AVG_TIMER_WAIT BETWEEN SUM_TIMER_WAIT * 0.98 AND SUM_TIMER_WAIT * 1.02 AND
+COUNT_READ * AVG_TIMER_READ BETWEEN SUM_TIMER_READ * 0.98 AND SUM_TIMER_READ * 1.02 AND
+COUNT_WRITE * AVG_TIMER_WRITE BETWEEN SUM_TIMER_WRITE * 0.98 AND SUM_TIMER_WRITE * 1.02 AND
+COUNT_MISC * AVG_TIMER_MISC BETWEEN SUM_TIMER_MISC * 0.98 AND SUM_TIMER_MISC * 1.02
+SELECT EVENT_NAME, OBJECT_INSTANCE_BEGIN,
+SUM_TIMER_WAIT * 0.98, COUNT_STAR * AVG_TIMER_WAIT, SUM_TIMER_WAIT * 1.02,
+COUNT_STAR, SUM_TIMER_WAIT, AVG_TIMER_WAIT,
+SUM_TIMER_READ * 0.98, COUNT_READ * AVG_TIMER_READ, SUM_TIMER_READ * 1.02,
+COUNT_READ, SUM_TIMER_READ, AVG_TIMER_READ,
+SUM_TIMER_WRITE * 0.98, COUNT_WRITE * AVG_TIMER_WRITE, SUM_TIMER_WRITE * 1.02,
+COUNT_WRITE, SUM_TIMER_WRITE, AVG_TIMER_WRITE,
+SUM_TIMER_MISC * 0.98, COUNT_MISC * AVG_TIMER_MISC, SUM_TIMER_MISC * 1.02,
+COUNT_MISC, SUM_TIMER_MISC, AVG_TIMER_MISC
+FROM mysqltest.my_socket_summary_by_instance
+WHERE pk = 'After' AND NOT (COUNT_STAR * AVG_TIMER_WAIT BETWEEN SUM_TIMER_WAIT * 0.98 AND SUM_TIMER_WAIT * 1.02 AND
+COUNT_READ * AVG_TIMER_READ BETWEEN SUM_TIMER_READ * 0.98 AND SUM_TIMER_READ * 1.02 AND
+COUNT_WRITE * AVG_TIMER_WRITE BETWEEN SUM_TIMER_WRITE * 0.98 AND SUM_TIMER_WRITE * 1.02 AND
+COUNT_MISC * AVG_TIMER_MISC BETWEEN SUM_TIMER_MISC * 0.98 AND SUM_TIMER_MISC * 1.02)
+ORDER BY EVENT_NAME, OBJECT_INSTANCE_BEGIN;
+EVENT_NAME wait/io/socket/sql/client_connection
+OBJECT_INSTANCE_BEGIN 140059017055744
+SUM_TIMER_WAIT * 0.98 28392560.00
+COUNT_STAR * AVG_TIMER_WAIT 28971000
+SUM_TIMER_WAIT * 1.02 29551440.00
+COUNT_STAR 9
+SUM_TIMER_WAIT 28972000
+AVG_TIMER_WAIT 3219000
+SUM_TIMER_READ * 0.98 52920.00
+COUNT_READ * AVG_TIMER_READ 52000
+SUM_TIMER_READ * 1.02 55080.00
+COUNT_READ 4
+SUM_TIMER_READ 54000
+AVG_TIMER_READ 13000
+SUM_TIMER_WRITE * 0.98 6774740.00

+COUNT_WRITE * AVG_TIMER_WRITE 6912000
+SUM_TIMER_WRITE * 1.02 7051260.00
+COUNT_WRITE 3
+SUM_TIMER_WRITE 6913000
+AVG_TIMER_WRITE 2304000
+SUM_TIMER_MISC * 0.98 21564900.00
+COUNT_MISC * AVG_TIMER_MISC 22004000
+SUM_TIMER_MISC * 1.02 22445100.00
+COUNT_MISC 2
+SUM_TIMER_MISC 22005000
+AVG_TIMER_MISC 11002000
# 2.4 Connect should pass, host = localhost
# length of user name = 4 character
# length of default db = 14 character (5 more than 2.3)
@@ -217,6 +264,909 @@
# 5. Check the impact of TRUNCATE on socket_summary_by_instance.
# It must reset all counters.
TRUNCATE TABLE performance_schema.socket_summary_by_instance;
+# Dump detailed differences after - before statement execution
+# 1. The statement executing connection and hopefully no one else
+SELECT @default_object_instance_begin;
+@default_object_instance_begin
+140059017046784
+SELECT EVENT_NAME, OBJECT_INSTANCE_BEGIN,
+COUNT_READ, SUM_NUMBER_OF_BYTES_READ,
+COUNT_WRITE, SUM_NUMBER_OF_BYTES_WRITE,
+COUNT_MISC, statement
+FROM mysqltest.socket_summary_by_instance_detail
+WHERE EVENT_NAME LIKE '%client_connection%'
+ AND OBJECT_INSTANCE_BEGIN <> @default_object_instance_begin
+ORDER BY statement, run;
+EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC statement
+wait/io/socket/sql/client_connection 140059017066304 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017066624 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017066944 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017067264 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017067584 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017067904 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017068224 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017068544 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017068864 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017069184 4 209 3 140 3 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017056704 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017057024 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017057344 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017057664 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017057984 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017058304 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017058624 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017058944 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017059264 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017059584 4 214 3 140 2 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 140059017053504 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017053824 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017054144 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017054464 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017054784 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017055104 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017055424 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017055744 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017056064 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017056384 4 209 3 140 2 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017059904 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017060224 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017060544 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017060864 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017061184 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017061504 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017061824 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017062144 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017062464 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017062784 4 215 3 140 2 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017063104 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017063424 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017063744 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017064064 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017064384 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017064704 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017065024 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017065344 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017065664 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017065984 4 219 3 140 2 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 66 1 86 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 32 1 59 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 59 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 47 1 164 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 36 1 63 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 88 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 50 1 78 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 83 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 84 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 140059017069504 1 49 1 1109 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+# 2. The connection default
+SELECT EVENT_NAME,
+COUNT_READ, SUM_NUMBER_OF_BYTES_READ,
+COUNT_WRITE, SUM_NUMBER_OF_BYTES_WRITE,
+COUNT_MISC, statement
+FROM mysqltest.socket_summary_by_instance_detail
+WHERE OBJECT_INSTANCE_BEGIN = @default_object_instance_begin
+ORDER BY statement,run;
+EVENT_NAME COUNT_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC statement
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/client_connection 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+# 3. The "server_unix_socket"
+SELECT EVENT_NAME,
+COUNT_READ, SUM_NUMBER_OF_BYTES_READ,
+COUNT_WRITE, SUM_NUMBER_OF_BYTES_WRITE,
+COUNT_MISC, statement
+FROM mysqltest.socket_summary_by_instance_detail
+WHERE EVENT_NAME LIKE '%server_unix_socket%'
+ ORDER BY statement,run;
+EVENT_NAME COUNT_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC statement
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 1 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+# 4. The "server_tcpip_socket"
+SELECT EVENT_NAME,
+COUNT_READ, SUM_NUMBER_OF_BYTES_READ,
+COUNT_WRITE, SUM_NUMBER_OF_BYTES_WRITE,
+COUNT_MISC, statement
+FROM mysqltest.socket_summary_by_instance_detail
+WHERE EVENT_NAME LIKE '%server_tcpip_socket%'
+ ORDER BY statement,run;
+EVENT_NAME COUNT_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC statement
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 1 Connect (con*,127.0.0.1,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,boot0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqlsupertest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root012345,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 Connect (con*,localhost,root0123456789,,mysqltest,,)
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 AS my_super_col FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 = 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist WHERE col1 A 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM does_not_exist0123
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 < 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = -1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 1
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 2
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 SELECT col2 FROM mysqltest.my_aux WHERE col1 = 3
+# 5. mysqltest.my_socket_summary_by_instance
+SELECT * FROM mysqltest.my_socket_summary_by_instance;
+EVENT_NAME wait/io/socket/sql/server_tcpip_socket
+OBJECT_INSTANCE_BEGIN 140059017031744
+COUNT_STAR 10
+SUM_TIMER_WAIT 41035000
+MIN_TIMER_WAIT 0
+AVG_TIMER_WAIT 4103000
+MAX_TIMER_WAIT 5219000
+COUNT_READ 0
+SUM_TIMER_READ 0
+MIN_TIMER_READ 0
+AVG_TIMER_READ 0
+MAX_TIMER_READ 0
+SUM_NUMBER_OF_BYTES_READ 0
+COUNT_WRITE 0
+SUM_TIMER_WRITE 0
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 0
+MAX_TIMER_WRITE 0
+SUM_NUMBER_OF_BYTES_WRITE 0
+COUNT_MISC 10
+SUM_TIMER_MISC 41035000
+MIN_TIMER_MISC 0
+AVG_TIMER_MISC 4103000
+MAX_TIMER_MISC 5219000
+pk Before
+EVENT_NAME wait/io/socket/sql/server_unix_socket
+OBJECT_INSTANCE_BEGIN 140059017032064
+COUNT_STAR 61
+SUM_TIMER_WAIT 341389000
+MIN_TIMER_WAIT 1054000
+AVG_TIMER_WAIT 5596000
+MAX_TIMER_WAIT 12585000
+COUNT_READ 0
+SUM_TIMER_READ 0
+MIN_TIMER_READ 0
+AVG_TIMER_READ 0
+MAX_TIMER_READ 0
+SUM_NUMBER_OF_BYTES_READ 0
+COUNT_WRITE 0
+SUM_TIMER_WRITE 0
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 0
+MAX_TIMER_WRITE 0
+SUM_NUMBER_OF_BYTES_WRITE 0
+COUNT_MISC 61
+SUM_TIMER_MISC 341389000
+MIN_TIMER_MISC 1054000
+AVG_TIMER_MISC 5596000
+MAX_TIMER_MISC 12585000
+pk Before
+EVENT_NAME wait/io/socket/sql/client_connection
+OBJECT_INSTANCE_BEGIN 140059017046784
+COUNT_STAR 0
+SUM_TIMER_WAIT 0
+MIN_TIMER_WAIT 0
+AVG_TIMER_WAIT 0
+MAX_TIMER_WAIT 0
+COUNT_READ 0
+SUM_TIMER_READ 0
+MIN_TIMER_READ 0
+AVG_TIMER_READ 0
+MAX_TIMER_READ 0
+SUM_NUMBER_OF_BYTES_READ 0
+COUNT_WRITE 0
+SUM_TIMER_WRITE 0
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 0
+MAX_TIMER_WRITE 0
+SUM_NUMBER_OF_BYTES_WRITE 0
+COUNT_MISC 0
+SUM_TIMER_MISC 0
+MIN_TIMER_MISC 0
+AVG_TIMER_MISC 0
+MAX_TIMER_MISC 0
+pk Before
+EVENT_NAME wait/io/socket/sql/client_connection
+OBJECT_INSTANCE_BEGIN 140059017069504
+COUNT_STAR 207
+SUM_TIMER_WAIT 794531000
+MIN_TIMER_WAIT 0
+AVG_TIMER_WAIT 3838000
+MAX_TIMER_WAIT 26962000
+COUNT_READ 103
+SUM_TIMER_READ 246294000
+MIN_TIMER_READ 0
+AVG_TIMER_READ 2391000
+MAX_TIMER_READ 26962000
+SUM_NUMBER_OF_BYTES_READ 4900
+COUNT_WRITE 102
+SUM_TIMER_WRITE 526500000
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 5161000
+MAX_TIMER_WRITE 26682000
+SUM_NUMBER_OF_BYTES_WRITE 18782
+COUNT_MISC 2
+SUM_TIMER_MISC 21737000
+MIN_TIMER_MISC 706000
+AVG_TIMER_MISC 10868000
+MAX_TIMER_MISC 21031000
+pk Before
+EVENT_NAME wait/io/socket/sql/server_tcpip_socket
+OBJECT_INSTANCE_BEGIN 140059017031744
+COUNT_STAR 10
+SUM_TIMER_WAIT 41035000
+MIN_TIMER_WAIT 0
+AVG_TIMER_WAIT 4103000
+MAX_TIMER_WAIT 5219000
+COUNT_READ 0
+SUM_TIMER_READ 0
+MIN_TIMER_READ 0
+AVG_TIMER_READ 0
+MAX_TIMER_READ 0
+SUM_NUMBER_OF_BYTES_READ 0
+COUNT_WRITE 0
+SUM_TIMER_WRITE 0
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 0
+MAX_TIMER_WRITE 0
+SUM_NUMBER_OF_BYTES_WRITE 0
+COUNT_MISC 10
+SUM_TIMER_MISC 41035000
+MIN_TIMER_MISC 0
+AVG_TIMER_MISC 4103000
+MAX_TIMER_MISC 5219000
+pk After
+EVENT_NAME wait/io/socket/sql/server_unix_socket
+OBJECT_INSTANCE_BEGIN 140059017032064
+COUNT_STAR 61
+SUM_TIMER_WAIT 341389000
+MIN_TIMER_WAIT 1054000
+AVG_TIMER_WAIT 5596000
+MAX_TIMER_WAIT 12585000
+COUNT_READ 0
+SUM_TIMER_READ 0
+MIN_TIMER_READ 0
+AVG_TIMER_READ 0
+MAX_TIMER_READ 0
+SUM_NUMBER_OF_BYTES_READ 0
+COUNT_WRITE 0
+SUM_TIMER_WRITE 0
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 0
+MAX_TIMER_WRITE 0
+SUM_NUMBER_OF_BYTES_WRITE 0
+COUNT_MISC 61
+SUM_TIMER_MISC 341389000
+MIN_TIMER_MISC 1054000
+AVG_TIMER_MISC 5596000
+MAX_TIMER_MISC 12585000
+pk After
+EVENT_NAME wait/io/socket/sql/client_connection
+OBJECT_INSTANCE_BEGIN 140059017046784
+COUNT_STAR 0
+SUM_TIMER_WAIT 0
+MIN_TIMER_WAIT 0
+AVG_TIMER_WAIT 0
+MAX_TIMER_WAIT 0
+COUNT_READ 0
+SUM_TIMER_READ 0
+MIN_TIMER_READ 0
+AVG_TIMER_READ 0
+MAX_TIMER_READ 0
+SUM_NUMBER_OF_BYTES_READ 0
+COUNT_WRITE 0
+SUM_TIMER_WRITE 0
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 0
+MAX_TIMER_WRITE 0
+SUM_NUMBER_OF_BYTES_WRITE 0
+COUNT_MISC 0
+SUM_TIMER_MISC 0
+MIN_TIMER_MISC 0
+AVG_TIMER_MISC 0
+MAX_TIMER_MISC 0
+pk After
+EVENT_NAME wait/io/socket/sql/client_connection
+OBJECT_INSTANCE_BEGIN 140059017069504
+COUNT_STAR 209
+SUM_TIMER_WAIT 802318000
+MIN_TIMER_WAIT 0
+AVG_TIMER_WAIT 3838000
+MAX_TIMER_WAIT 26962000
+COUNT_READ 104
+SUM_TIMER_READ 248205000
+MIN_TIMER_READ 0
+AVG_TIMER_READ 2386000
+MAX_TIMER_READ 26962000
+SUM_NUMBER_OF_BYTES_READ 4949
+COUNT_WRITE 103
+SUM_TIMER_WRITE 532376000
+MIN_TIMER_WRITE 0
+AVG_TIMER_WRITE 5168000
+MAX_TIMER_WRITE 26682000
+SUM_NUMBER_OF_BYTES_WRITE 18870
+COUNT_MISC 2
+SUM_TIMER_MISC 21737000
+MIN_TIMER_MISC 706000
+AVG_TIMER_MISC 10868000
+MAX_TIMER_MISC 21031000
+pk After
# 6. Cleanup
connection default;
set global session_track_schema=DEFAULT;

mysqltest: Result length mismatch

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-05-07 18:10

Updated:: 2023-11-29 17:33

Resolved:: 2023-11-29 17:33

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.