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