List:Commits« Previous MessageNext Message »
From:Christopher Powers Date:July 22 2011 5:35pm
Subject:bzr push into mysql-trunk branch (chris.powers:3328 to 3329) WL#4896
View as plain text  
 3329 Christopher Powers	2011-07-22
      WL#4896 "Performance Schema Net IO"
      
      Debugging socket_instances_func.test

    modified:
      mysql-test/suite/perfschema/r/socket_instances_func.result*
      mysql-test/suite/perfschema/t/socket_instances_func.test
 3328 Christopher Powers	2011-07-21
      Debugging testcase behavior on PB

    modified:
      mysql-test/suite/perfschema/t/socket_instances_func.test
=== modified file 'mysql-test/suite/perfschema/r/socket_instances_func.result' (properties changed: -x to +x)
--- a/mysql-test/suite/perfschema/r/socket_instances_func.result	2011-07-21 00:12:39 +0000
+++ b/mysql-test/suite/perfschema/r/socket_instances_func.result	2011-07-22 17:34:24 +0000
@@ -1,11 +1,57 @@
 # Take a snapshot of SOCKET_INSTANCES
 CREATE TEMPORARY TABLE my_socket_instances AS
 SELECT * FROM performance_schema.socket_instances;
+# DEBUG 1
+SELECT * FROM performance_schema.socket_instances;
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
+current_user()
+root@localhost
+user()
+root@localhost
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/client_connection    140614630554288 17      60      127.0.0.1       57022   ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
+# DEBUG 1a
+SELECT * FROM performance_schema.socket_instances;
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
 # Get thread id of the default connection
 SELECT THREAD_ID INTO @thread_id
 FROM performance_schema.threads
 WHERE PROCESSLIST_ID = CONNECTION_ID();
 # Establish local TCP/IP connection (con1,127.0.0.1,root,,test,,)
+# DEBUG 2
+SELECT * FROM performance_schema.socket_instances;
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/client_connection    140614630501200 18      60      127.0.0.1       57023   ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
+# /home/cpowers/work/dev/mysql-trunk-wl4896/client//mysql --defaults-file=/home/cpowers/work/dev/mysql-trunk-wl4896/mysql-test/var/my.cnf --host=127.0.0.1 --port=13000 --user=root test -e "SELECT current_user();SELECT user();SELECT * FROM performance_schema.socket_instances;"
+current_user()
+root@localhost
+user()
+root@localhost
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/client_connection    140614630501200 18      60      127.0.0.1       57023   ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
+wait/io/socket/sql/client_connection    140614630639184 19      61      127.0.0.1       57024   ACTIVE
+# DEBUG 2a
+SELECT * FROM performance_schema.socket_instances;
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/client_connection    140614630501200 18      60      127.0.0.1       57023   ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
 # Store the thread id of connection 1 (tcp/ip)
 SELECT THREAD_ID INTO @thread_id
 FROM performance_schema.threads
@@ -16,6 +62,14 @@ FROM performance_schema.socket_instances
 WHERE THREAD_ID = @thread_id;
 # Switch to connection default
 # Establish a second local TCP/IP connection (con2,127.0.0.1,root,,test,,)
+# DEBUG 3
+SELECT * FROM performance_schema.socket_instances;
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630434448 20      61      127.0.0.1       57025   ACTIVE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/client_connection    140614630501200 18      60      127.0.0.1       57023   ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
 # Store the thread_id of connection 2 (tcp/ip)
 SELECT THREAD_ID INTO @thread_id
 FROM performance_schema.threads
@@ -26,6 +80,15 @@ FROM performance_schema.socket_instances
 WHERE THREAD_ID = @thread_id;
 # Switch to connection default
 # Establish local unix domain connection (con3,localhost,root,,test,,)
+# DEBUG 4
+SELECT * FROM performance_schema.socket_instances;
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE
+wait/io/socket/sql/client_connection    140614630434448 20      61      127.0.0.1       57025   ACTIVE
+wait/io/socket/sql/client_connection    140614630474768 16      37              0       ACTIVE
+wait/io/socket/sql/client_connection    140614630501200 18      60      127.0.0.1       57023   ACTIVE
+wait/io/socket/sql/server_unix_socket   140614630501424 1       14              0       ACTIVE
+wait/io/socket/sql/client_connection    140614630572880 21      62              0       ACTIVE
+wait/io/socket/sql/server_tcpip_socket  140614630574448 1       13      0.0.0.0 13000   ACTIVE
 # Store the thread id of connection 3 (unix domain)
 SELECT THREAD_ID INTO @thread_id
 FROM performance_schema.threads
@@ -190,10 +253,10 @@ WHERE (EVENT_NAME,OBJECT_INSTANCE_BEGIN,
 NOT IN (SELECT EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE
 FROM my_socket_instances)
 ORDER BY THREAD_ID;
-EVENT_NAME	IP
-wait/io/socket/sql/client_connection	127.0.0.1
-wait/io/socket/sql/client_connection	127.0.0.1
-wait/io/socket/sql/client_connection	
+EVENT_NAME      IP
+wait/io/socket/sql/client_connection    127.0.0.1
+wait/io/socket/sql/client_connection    127.0.0.1
+wait/io/socket/sql/client_connection
 # Disconnect con1, con2 and con3
 # Show differences to socket_instances before con1,con1 connecting.
 # There should be none.
@@ -203,4 +266,4 @@ WHERE (EVENT_NAME,OBJECT_INSTANCE_BEGIN,
 NOT IN (SELECT EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE
 FROM my_socket_instances)
 ORDER BY THREAD_ID;
-EVENT_NAME	OBJECT_INSTANCE_BEGIN	THREAD_ID	SOCKET_ID	IP	PORT	STATE
+EVENT_NAME      OBJECT_INSTANCE_BEGIN   THREAD_ID       SOCKET_ID       IP      PORT    STATE

=== modified file 'mysql-test/suite/perfschema/t/socket_instances_func.test'
--- a/mysql-test/suite/perfschema/t/socket_instances_func.test	2011-07-21 20:26:55 +0000
+++ b/mysql-test/suite/perfschema/t/socket_instances_func.test	2011-07-22 17:34:24 +0000
@@ -28,6 +28,9 @@ SELECT * FROM performance_schema.socket_
 
 --echo # DEBUG 1
 SELECT * FROM performance_schema.socket_instances;
+--exec $MYSQL --host=127.0.0.1 --port=$MASTER_MYPORT --user=root test -e "SELECT current_user();SELECT user();SELECT * FROM performance_schema.socket_instances;"
+--echo # DEBUG 1a
+SELECT * FROM performance_schema.socket_instances;
 
 # Get the thread id of this connection
 --echo # Get thread id of the default connection
@@ -49,6 +52,10 @@ let $con0_thread_id = `SELECT @thread_id
 
 --echo # DEBUG 2
 SELECT * FROM performance_schema.socket_instances;
+--echo # $MYSQL --host=127.0.0.1 --port=$MASTER_MYPORT --user=root test -e "SELECT current_user();SELECT user();SELECT * FROM performance_schema.socket_instances;"
+--exec $MYSQL --host=127.0.0.1 --port=$MASTER_MYPORT --user=root test -e "SELECT current_user();SELECT user();SELECT * FROM performance_schema.socket_instances;"
+--echo # DEBUG 2a
+SELECT * FROM performance_schema.socket_instances;
 
 --echo # Store the thread id of connection 1 (tcp/ip)
 SELECT THREAD_ID INTO @thread_id

No bundle (reason: useless for push emails).
Thread
bzr push into mysql-trunk branch (chris.powers:3328 to 3329) WL#4896Christopher Powers22 Jul