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
|