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