| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection master] |
| 6 |
#### Specify scenarios #### |
| 7 |
|
| 8 |
#### Initialize Server State #### |
| 9 |
include/disable_binlog.inc |
| 10 |
SET @save_replica_parallel_workers = @@global.replica_parallel_workers; |
| 11 |
SET @@global.replica_parallel_workers = 4; |
| 12 |
include/start_slave_sql.inc |
| 13 |
SET @save_replica_net_timeout = @@global.replica_net_timeout; |
| 14 |
SET @@global.replica_net_timeout = 300; |
| 15 |
CREATE TABLE statement_result (name VARCHAR(256), KEY(name)); |
| 16 |
include/disable_binlog.inc |
| 17 |
CREATE TABLE statement_result (name VARCHAR(256), KEY(name)); |
| 18 |
# Adding debug point 'syncpoint_begin_register_replica' to @@GLOBAL.debug |
| 19 |
SET @@session.debug_sync = "now WAIT_FOR reached_begin_register_replica"; |
| 20 |
START REPLICA IO_THREAD; |
| 21 |
|
| 22 |
#### Test terminology_use_previous=0 #### |
| 23 |
|
| 24 |
SET @@session.terminology_use_previous = 0; |
| 25 |
Warnings: |
| 26 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 27 |
SELECT @@session.terminology_use_previous; |
| 28 |
@@session.terminology_use_previous |
| 29 |
NONE |
| 30 |
Warnings: |
| 31 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 32 |
SET @@session.terminology_use_previous = 0; |
| 33 |
Warnings: |
| 34 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 35 |
SELECT @@session.terminology_use_previous; |
| 36 |
@@session.terminology_use_previous |
| 37 |
NONE |
| 38 |
Warnings: |
| 39 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 40 |
|
| 41 |
---- mutex ---- |
| 42 |
* performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) |
| 43 |
include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 44 |
include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 45 |
* performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) |
| 46 |
include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 47 |
include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 48 |
* performance_schema.events_waits_summary_by_instance(EVENT_NAME) |
| 49 |
include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 50 |
include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 51 |
* performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) |
| 52 |
include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 53 |
include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 54 |
* performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) |
| 55 |
include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 56 |
include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 57 |
* performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) |
| 58 |
include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 59 |
include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 60 |
* performance_schema.mutex_instances(NAME) |
| 61 |
include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.mutex_instances(NAME) on server 2] |
| 62 |
include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.mutex_instances(NAME) on server 2] |
| 63 |
|
| 64 |
---- rwlock ---- |
| 65 |
* performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) |
| 66 |
include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 67 |
include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 68 |
* performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) |
| 69 |
include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 70 |
include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 71 |
* performance_schema.events_waits_summary_by_instance(EVENT_NAME) |
| 72 |
include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 73 |
include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 74 |
* performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) |
| 75 |
include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 76 |
include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 77 |
* performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) |
| 78 |
include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 79 |
include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 80 |
* performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) |
| 81 |
include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 82 |
include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 83 |
* performance_schema.rwlock_instances(NAME) |
| 84 |
include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.rwlock_instances(NAME) on server 2] |
| 85 |
include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.rwlock_instances(NAME) on server 2] |
| 86 |
|
| 87 |
---- cond ---- |
| 88 |
* performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) |
| 89 |
include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 90 |
include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 91 |
* performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) |
| 92 |
include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 93 |
include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 94 |
* performance_schema.events_waits_summary_by_instance(EVENT_NAME) |
| 95 |
include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 96 |
include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 97 |
* performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) |
| 98 |
include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 99 |
include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 100 |
* performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) |
| 101 |
include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 102 |
include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 103 |
* performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) |
| 104 |
include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 105 |
include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 106 |
* performance_schema.cond_instances(NAME) |
| 107 |
include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.cond_instances(NAME) on server 2] |
| 108 |
include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.cond_instances(NAME) on server 2] |
| 109 |
|
| 110 |
---- memory ---- |
| 111 |
* performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) |
| 112 |
include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 113 |
include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 114 |
* performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) |
| 115 |
include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 116 |
include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 117 |
* performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) |
| 118 |
include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 119 |
include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 120 |
* performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) |
| 121 |
include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 122 |
include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 123 |
* performance_schema.memory_summary_global_by_event_name(EVENT_NAME) |
| 124 |
include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 125 |
include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 126 |
|
| 127 |
---- thread ---- |
| 128 |
* performance_schema.threads(NAME) |
| 129 |
include/assert.inc [There should be 3 unique 'new' thread names in performance_schema.threads(NAME) on server 2] |
| 130 |
include/assert.inc [There should be 0 unique 'old' thread names in performance_schema.threads(NAME) on server 2] |
| 131 |
|
| 132 |
---- stage ---- |
| 133 |
* performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) |
| 134 |
include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 135 |
include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 136 |
* performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) |
| 137 |
include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 138 |
include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 139 |
* performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) |
| 140 |
include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 141 |
include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 142 |
* performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) |
| 143 |
include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 144 |
include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 145 |
* performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) |
| 146 |
include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 147 |
include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 148 |
* performance_schema.threads(PROCESSLIST_STATE) |
| 149 |
include/assert.inc [There should be 2 unique 'new' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2] |
| 150 |
include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2] |
| 151 |
* performance_schema.processlist(STATE) |
| 152 |
include/assert.inc [There should be 2 unique 'new' stage names in performance_schema.processlist(STATE) on server 2] |
| 153 |
include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.processlist(STATE) on server 2] |
| 154 |
* INFORMATION_SCHEMA.PROCESSLIST(STATE) |
| 155 |
include/assert.inc [There should be 2 unique 'new' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2] |
| 156 |
include/assert.inc [There should be 0 unique 'old' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2] |
| 157 |
* SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) |
| 158 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 159 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 160 |
include/assert.inc [There should be 2 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2] |
| 161 |
include/assert.inc [There should be 0 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2] |
| 162 |
* SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) |
| 163 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 164 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 165 |
include/assert.inc [There should be 2 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2] |
| 166 |
include/assert.inc [There should be 0 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2] |
| 167 |
|
| 168 |
---- command ---- |
| 169 |
* performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) |
| 170 |
include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1] |
| 171 |
include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1] |
| 172 |
* performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) |
| 173 |
include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1] |
| 174 |
include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1] |
| 175 |
* performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) |
| 176 |
include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1] |
| 177 |
include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1] |
| 178 |
* performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) |
| 179 |
include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1] |
| 180 |
include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1] |
| 181 |
* performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) |
| 182 |
include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1] |
| 183 |
include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1] |
| 184 |
* performance_schema.threads(PROCESSLIST_COMMAND) |
| 185 |
include/assert.inc [There should be 1 unique 'new' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1] |
| 186 |
include/assert.inc [There should be 0 unique 'old' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1] |
| 187 |
* performance_schema.processlist(COMMAND) |
| 188 |
include/assert.inc [There should be 1 unique 'new' command names in performance_schema.processlist(COMMAND) on server 1] |
| 189 |
include/assert.inc [There should be 0 unique 'old' command names in performance_schema.processlist(COMMAND) on server 1] |
| 190 |
* INFORMATION_SCHEMA.PROCESSLIST(COMMAND) |
| 191 |
include/assert.inc [There should be 1 unique 'new' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1] |
| 192 |
include/assert.inc [There should be 0 unique 'old' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1] |
| 193 |
* SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) |
| 194 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 195 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 196 |
include/assert.inc [There should be 1 unique 'new' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1] |
| 197 |
include/assert.inc [There should be 0 unique 'old' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1] |
| 198 |
* SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) |
| 199 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 200 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 201 |
include/assert.inc [There should be 1 unique 'new' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1] |
| 202 |
include/assert.inc [There should be 0 unique 'old' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1] |
| 203 |
* SHOW REPLICA STATUS(column 1) |
| 204 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result] |
| 205 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result] |
| 206 |
include/assert.inc [There should be 1 unique 'new' command names in SHOW REPLICA STATUS(column 1) on server 1] |
| 207 |
include/assert.inc [There should be 0 unique 'old' command names in SHOW REPLICA STATUS(column 1) on server 1] |
| 208 |
* SHOW REPLICA STATUS(column 45) |
| 209 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result] |
| 210 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result] |
| 211 |
include/assert.inc [There should be 1 unique 'new' command names in SHOW REPLICA STATUS(column 45) on server 1] |
| 212 |
include/assert.inc [There should be 0 unique 'old' command names in SHOW REPLICA STATUS(column 45) on server 1] |
| 213 |
* SHOW SLAVE STATUS(column 1) |
| 214 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result] |
| 215 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result] |
| 216 |
include/assert.inc [There should be 1 unique 'new' command names in SHOW SLAVE STATUS(column 1) on server 1] |
| 217 |
include/assert.inc [There should be 0 unique 'old' command names in SHOW SLAVE STATUS(column 1) on server 1] |
| 218 |
* SHOW SLAVE STATUS(column 45) |
| 219 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result] |
| 220 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result] |
| 221 |
include/assert.inc [There should be 1 unique 'new' command names in SHOW SLAVE STATUS(column 45) on server 1] |
| 222 |
include/assert.inc [There should be 0 unique 'old' command names in SHOW SLAVE STATUS(column 45) on server 1] |
| 223 |
|
| 224 |
#### Test terminology_use_previous=1 #### |
| 225 |
|
| 226 |
SET @@session.terminology_use_previous = 1; |
| 227 |
Warnings: |
| 228 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 229 |
SELECT @@session.terminology_use_previous; |
| 230 |
@@session.terminology_use_previous |
| 231 |
BEFORE_8_0_26 |
| 232 |
Warnings: |
| 233 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 234 |
SET @@session.terminology_use_previous = 1; |
| 235 |
Warnings: |
| 236 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 237 |
SELECT @@session.terminology_use_previous; |
| 238 |
@@session.terminology_use_previous |
| 239 |
BEFORE_8_0_26 |
| 240 |
Warnings: |
| 241 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 242 |
|
| 243 |
---- mutex ---- |
| 244 |
* performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) |
| 245 |
include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 246 |
include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 247 |
* performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) |
| 248 |
include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 249 |
include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 250 |
* performance_schema.events_waits_summary_by_instance(EVENT_NAME) |
| 251 |
include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 252 |
include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 253 |
* performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) |
| 254 |
include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 255 |
include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 256 |
* performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) |
| 257 |
include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 258 |
include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 259 |
* performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) |
| 260 |
include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 261 |
include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 262 |
* performance_schema.mutex_instances(NAME) |
| 263 |
include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.mutex_instances(NAME) on server 2] |
| 264 |
include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.mutex_instances(NAME) on server 2] |
| 265 |
|
| 266 |
---- rwlock ---- |
| 267 |
* performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) |
| 268 |
include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 269 |
include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 270 |
* performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) |
| 271 |
include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 272 |
include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 273 |
* performance_schema.events_waits_summary_by_instance(EVENT_NAME) |
| 274 |
include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 275 |
include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 276 |
* performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) |
| 277 |
include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 278 |
include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 279 |
* performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) |
| 280 |
include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 281 |
include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 282 |
* performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) |
| 283 |
include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 284 |
include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 285 |
* performance_schema.rwlock_instances(NAME) |
| 286 |
include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.rwlock_instances(NAME) on server 2] |
| 287 |
include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.rwlock_instances(NAME) on server 2] |
| 288 |
|
| 289 |
---- cond ---- |
| 290 |
* performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) |
| 291 |
include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 292 |
include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 293 |
* performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) |
| 294 |
include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 295 |
include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 296 |
* performance_schema.events_waits_summary_by_instance(EVENT_NAME) |
| 297 |
include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 298 |
include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2] |
| 299 |
* performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) |
| 300 |
include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 301 |
include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 302 |
* performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) |
| 303 |
include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 304 |
include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 305 |
* performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) |
| 306 |
include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 307 |
include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 308 |
* performance_schema.cond_instances(NAME) |
| 309 |
include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.cond_instances(NAME) on server 2] |
| 310 |
include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.cond_instances(NAME) on server 2] |
| 311 |
|
| 312 |
---- memory ---- |
| 313 |
* performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) |
| 314 |
include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 315 |
include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 316 |
* performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) |
| 317 |
include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 318 |
include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 319 |
* performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) |
| 320 |
include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 321 |
include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 322 |
* performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) |
| 323 |
include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 324 |
include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 325 |
* performance_schema.memory_summary_global_by_event_name(EVENT_NAME) |
| 326 |
include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 327 |
include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 328 |
|
| 329 |
---- thread ---- |
| 330 |
* performance_schema.threads(NAME) |
| 331 |
include/assert.inc [There should be 0 unique 'new' thread names in performance_schema.threads(NAME) on server 2] |
| 332 |
include/assert.inc [There should be 3 unique 'old' thread names in performance_schema.threads(NAME) on server 2] |
| 333 |
|
| 334 |
---- stage ---- |
| 335 |
* performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) |
| 336 |
include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 337 |
include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2] |
| 338 |
* performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) |
| 339 |
include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 340 |
include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2] |
| 341 |
* performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) |
| 342 |
include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 343 |
include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2] |
| 344 |
* performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) |
| 345 |
include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 346 |
include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2] |
| 347 |
* performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) |
| 348 |
include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 349 |
include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2] |
| 350 |
* performance_schema.threads(PROCESSLIST_STATE) |
| 351 |
include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2] |
| 352 |
include/assert.inc [There should be 2 unique 'old' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2] |
| 353 |
* performance_schema.processlist(STATE) |
| 354 |
include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.processlist(STATE) on server 2] |
| 355 |
include/assert.inc [There should be 2 unique 'old' stage names in performance_schema.processlist(STATE) on server 2] |
| 356 |
* INFORMATION_SCHEMA.PROCESSLIST(STATE) |
| 357 |
include/assert.inc [There should be 0 unique 'new' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2] |
| 358 |
include/assert.inc [There should be 2 unique 'old' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2] |
| 359 |
* SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) |
| 360 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 361 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 362 |
include/assert.inc [There should be 0 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2] |
| 363 |
include/assert.inc [There should be 2 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2] |
| 364 |
* SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) |
| 365 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 366 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 367 |
include/assert.inc [There should be 0 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2] |
| 368 |
include/assert.inc [There should be 2 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2] |
| 369 |
|
| 370 |
---- command ---- |
| 371 |
* performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) |
| 372 |
include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1] |
| 373 |
include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1] |
| 374 |
* performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) |
| 375 |
include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1] |
| 376 |
include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1] |
| 377 |
* performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) |
| 378 |
include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1] |
| 379 |
include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1] |
| 380 |
* performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) |
| 381 |
include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1] |
| 382 |
include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1] |
| 383 |
* performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) |
| 384 |
include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1] |
| 385 |
include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1] |
| 386 |
* performance_schema.threads(PROCESSLIST_COMMAND) |
| 387 |
include/assert.inc [There should be 0 unique 'new' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1] |
| 388 |
include/assert.inc [There should be 1 unique 'old' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1] |
| 389 |
* performance_schema.processlist(COMMAND) |
| 390 |
include/assert.inc [There should be 0 unique 'new' command names in performance_schema.processlist(COMMAND) on server 1] |
| 391 |
include/assert.inc [There should be 1 unique 'old' command names in performance_schema.processlist(COMMAND) on server 1] |
| 392 |
* INFORMATION_SCHEMA.PROCESSLIST(COMMAND) |
| 393 |
include/assert.inc [There should be 0 unique 'new' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1] |
| 394 |
include/assert.inc [There should be 1 unique 'old' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1] |
| 395 |
* SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) |
| 396 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 397 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result] |
| 398 |
include/assert.inc [There should be 0 unique 'new' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1] |
| 399 |
include/assert.inc [There should be 1 unique 'old' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1] |
| 400 |
* SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) |
| 401 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 402 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result] |
| 403 |
include/assert.inc [There should be 0 unique 'new' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1] |
| 404 |
include/assert.inc [There should be 1 unique 'old' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1] |
| 405 |
* SHOW REPLICA STATUS(column 1) |
| 406 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result] |
| 407 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result] |
| 408 |
include/assert.inc [There should be 0 unique 'new' command names in SHOW REPLICA STATUS(column 1) on server 1] |
| 409 |
include/assert.inc [There should be 1 unique 'old' command names in SHOW REPLICA STATUS(column 1) on server 1] |
| 410 |
* SHOW REPLICA STATUS(column 45) |
| 411 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result] |
| 412 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result] |
| 413 |
include/assert.inc [There should be 0 unique 'new' command names in SHOW REPLICA STATUS(column 45) on server 1] |
| 414 |
include/assert.inc [There should be 1 unique 'old' command names in SHOW REPLICA STATUS(column 45) on server 1] |
| 415 |
* SHOW SLAVE STATUS(column 1) |
| 416 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result] |
| 417 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result] |
| 418 |
include/assert.inc [There should be 0 unique 'new' command names in SHOW SLAVE STATUS(column 1) on server 1] |
| 419 |
include/assert.inc [There should be 1 unique 'old' command names in SHOW SLAVE STATUS(column 1) on server 1] |
| 420 |
* SHOW SLAVE STATUS(column 45) |
| 421 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result] |
| 422 |
include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result] |
| 423 |
include/assert.inc [There should be 0 unique 'new' command names in SHOW SLAVE STATUS(column 45) on server 1] |
| 424 |
include/assert.inc [There should be 1 unique 'old' command names in SHOW SLAVE STATUS(column 45) on server 1] |
| 425 |
# Check SET terminology_use_previous = DEFAULT |
| 426 |
SET @@session.terminology_use_previous = DEFAULT; |
| 427 |
Warnings: |
| 428 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 429 |
SELECT @@session.terminology_use_previous; |
| 430 |
@@session.terminology_use_previous |
| 431 |
NONE |
| 432 |
Warnings: |
| 433 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 434 |
|
| 435 |
#### Clean up #### |
| 436 |
SET @@session.debug_sync = "now SIGNAL continue_begin_register_replica"; |
| 437 |
include/wait_for_slave_io_to_start.inc |
| 438 |
SET @@global.replica_parallel_workers = @save_replica_parallel_workers; |
| 439 |
SET @@global.replica_net_timeout = @save_replica_net_timeout; |
| 440 |
include/restore_binlog.inc |
| 441 |
# Removing debug point 'syncpoint_begin_register_replica' from @@GLOBAL.debug |
| 442 |
DROP TABLE statement_result; |
| 443 |
include/sync_slave_sql_with_master.inc |
| 444 |
include/rpl_end.inc |