Debian Codegraph @

mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result

raw
1 #==============================================================================
2 # Establish the level of IPV6 support
3 #==============================================================================
4 #==============================================================================
5 # Get hostname, port number
6 #==============================================================================
7 SELECT @@hostname INTO @MY_HOSTNAME;
8 SELECT @@port INTO @MY_MASTER_PORT;
9 #==============================================================================
10 # 1.0 TEST INITIALIZATION
11 #==============================================================================
12 #
13 # 1.1 Disable instrumentation of the default (this) connection
14 #
15 connection default;
16 UPDATE performance_schema.threads
17 SET INSTRUMENTED='NO' WHERE PROCESSLIST_ID = CONNECTION_ID();
18 #
19 # 1.2 Get the default THREAD_ID;
20 #
21 SELECT THREAD_ID INTO @my_thread_id
22 FROM performance_schema.threads
23 WHERE PROCESSLIST_ID = CONNECTION_ID();
24 #
25 # 1.3 Get the default OBJECT_INSTANCE_BEGIN
26 #
27 SELECT OBJECT_INSTANCE_BEGIN INTO @my_object_instance_begin
28 FROM performance_schema.socket_instances
29 WHERE THREAD_ID = @my_thread_id;
30 #
31 # 1.4 Create a test database
32 #
33 CREATE SCHEMA mysqltest;
34 #
35 # 1.5 Create a table to store summary values from socket_summary_by_instance
36 and socket_summary_by_event_name
37 #
38 CREATE TABLE mysqltest.my_socket_summary AS
39 SELECT * FROM performance_schema.socket_summary_by_instance
40 WHERE 1 = 0;
41 #
42 # 1.6 Drop object_instance_begin from my_socket_summary
43 #
44 ALTER TABLE mysqltest.my_socket_summary
45 DROP COLUMN OBJECT_INSTANCE_BEGIN;
46 #
47 # 1.7 Add an auto_inc column to my_socket_summary
48 #
49 ALTER TABLE mysqltest.my_socket_summary
50 ADD COLUMN (n INT AUTO_INCREMENT, PRIMARY KEY(n));
51 #
52 # 1.8 Create test tables
53 #
54 CREATE TABLE mysqltest.t1 (n INT AUTO_INCREMENT, s1 VARCHAR(1024), PRIMARY KEY(n));
55 CREATE TABLE mysqltest.t2 (n INT AUTO_INCREMENT, s1 VARCHAR(1024), PRIMARY KEY(n));
56 #==============================================================================
57 # 2.0 ESTABLISH CLIENT CONNECTIONS
58 #==============================================================================
59 #
60 # 2.1 Connection 1 (tcp/ip, 127.0.0.1 or ::1)
61 #
62 #
63 # 2.2 Connection 2 (localhost or unix domain socket)
64 #
65 #==============================================================================
66 # 3.0 RUN THE TESTS
67 #==============================================================================
68 #
69 # 3.1 Clear performance schema tables
70 #
71 TRUNCATE performance_schema.socket_summary_by_instance;
72 TRUNCATE performance_schema.socket_summary_by_event_name;
73 #
74 # 3.2 Get the 'before' sum of bytes written from socket_summary_by_instance
75 for later comparison to the 'after' byte count as a simple confirmation
76 that the table was updated.
77 #
78 connection default;
79 SELECT sum(SUM_NUMBER_OF_BYTES_WRITE) INTO @my_write_count
80 FROM performance_schema.socket_summary_by_instance;
81 #
82 # 3.3 From connection 1, insert one a 1K row of data into t1
83 #
84 connection con1;
85 USE mysqltest;
86 INSERT INTO t1 (s1) VALUES (REPEAT('a', 1024));
87 INSERT INTO t1 (s1) SELECT s1 FROM t1;
88 #
89 # 3.4 From connection 2, insert one a 1K row of data into t2
90 #
91 connection con2;
92 USE mysqltest;
93 INSERT INTO t2 (s1) VALUES (REPEAT('a', 1024));
94 INSERT INTO t2 (s1) SELECT s1 FROM t2;
95 #
96 # 3.5 Get the 'after' sum of bytes written from socket_summary_by_instance
97 #
98 connection default;
99 SELECT sum(SUM_NUMBER_OF_BYTES_WRITE) INTO @my_write_count
100 FROM performance_schema.socket_summary_by_instance;
101 #
102 # 3.6 Verify that SUM_NUMBER_OF_BYTES_WRITE increased
103 #
104 #
105 # socket_summary_by_instance was updated
106 #
107 #==============================================================================
108 # 4.0 VERIFY RESULTS
109 #==============================================================================
110 #
111 # 4.1 Verify that the totals in socket_summary_by_event_name are
112 consistent with totals in socket_summary_by_instance
113 #
114 #==============================================================================
115 # 5.0 Clean up
116 #==============================================================================
117 #
118 # 5.1 Disconnect con1
119 #
120 connection con1;
121 disconnect con1;
122 #
123 # 5.2 Disconnect con2
124 #
125 connection con2;
126 disconnect con2;
127 #
128 # 5.3 Drop mysqltest
129 #
130 connection default;
131 DROP DATABASE mysqltest;