Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19413

perfschema.socket_summary_by_instance_func failed in buildbot with wrong result

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2
    • Fix Version/s: 10.2
    • 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:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: