| 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; |