From: Christopher Powers Date: July 21 2011 8:29pm Subject: bzr push into mysql-trunk branch (chris.powers:3327 to 3328) List-Archive: http://lists.mysql.com/commits/140415 Message-Id: <201107212029.p6LKToEp030786@acsmt358.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3328 Christopher Powers 2011-07-21 Debugging testcase behavior on PB modified: mysql-test/suite/perfschema/t/socket_instances_func.test 3327 Christopher Powers 2011-07-20 WL#4896 "Performance Schema Net IO" - Touch up socket_instances_func test case for Windows modified: mysql-test/suite/perfschema/r/socket_instances_func_win.result mysql-test/suite/perfschema/t/socket_instances_func_win.test === modified file 'mysql-test/suite/perfschema/t/socket_instances_func.test' --- a/mysql-test/suite/perfschema/t/socket_instances_func.test 2011-07-21 00:12:39 +0000 +++ b/mysql-test/suite/perfschema/t/socket_instances_func.test 2011-07-21 20:26:55 +0000 @@ -26,6 +26,9 @@ CREATE TEMPORARY TABLE my_socket_instances AS SELECT * FROM performance_schema.socket_instances; +--echo # DEBUG 1 +SELECT * FROM performance_schema.socket_instances; + # Get the thread id of this connection --echo # Get thread id of the default connection SELECT THREAD_ID INTO @thread_id @@ -40,9 +43,12 @@ let $con0_thread_id = `SELECT @thread_id # Have a connection with IP = '127.0.0.1,' --echo # Establish local TCP/IP connection (con1,127.0.0.1,root,,test,,) ---disable_query_log +#--disable_query_log --connect (con1,127.0.0.1,root,,test,,$MASTER_MYPORT) ---enable_query_log +#--enable_query_log + +--echo # DEBUG 2 +SELECT * FROM performance_schema.socket_instances; --echo # Store the thread id of connection 1 (tcp/ip) SELECT THREAD_ID INTO @thread_id @@ -66,9 +72,12 @@ let $con1_port = `SELECT @port`; # Have a connection with IP = '127.0.0.1,' --echo # Establish a second local TCP/IP connection (con2,127.0.0.1,root,,test,,) ---disable_query_log +#--disable_query_log --connect (con2,127.0.0.1,root,,test,,$MASTER_MYPORT) ---enable_query_log +#--enable_query_log + +--echo # DEBUG 3 +SELECT * FROM performance_schema.socket_instances; --echo # Store the thread_id of connection 2 (tcp/ip) SELECT THREAD_ID INTO @thread_id @@ -94,6 +103,10 @@ let $con2_port = `SELECT @port`; --echo # Establish local unix domain connection (con3,localhost,root,,test,,) --connect(con3,localhost,root,,test,,) +--echo # DEBUG 4 +SELECT * FROM performance_schema.socket_instances; + + --echo # Store the thread id of connection 3 (unix domain) SELECT THREAD_ID INTO @thread_id FROM performance_schema.threads No bundle (reason: useless for push emails).