1CREATE TABLE t1 (f1 INT PRIMARY KEY) Engine=InnoDB; 2CREATE TABLE t2 (f1 INT AUTO_INCREMENT PRIMARY KEY) Engine=InnoDB; 3SET GLOBAL wsrep_slave_threads = 0; 4Warnings: 5Warning 1292 Truncated incorrect wsrep_slave_threads value: '0' 6SHOW WARNINGS; 7Level Code Message 8Warning 1292 Truncated incorrect wsrep_slave_threads value: '0' 9SELECT @@wsrep_slave_threads = 1; 10@@wsrep_slave_threads = 1 111 12SET GLOBAL wsrep_slave_threads = 1; 13SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user'; 14COUNT(*) = 2 151 16SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%'; 17COUNT(*) = 1 181 19SET GLOBAL wsrep_slave_threads = 64; 20INSERT INTO t1 VALUES (1); 21SELECT COUNT(*) = 1 FROM t1; 22COUNT(*) = 1 231 24SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user'; 25COUNT(*) = @@wsrep_slave_threads + 1 261 27SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%'; 28COUNT(*) = 1 291 30SET GLOBAL wsrep_slave_threads = 1; 31INSERT INTO t2 VALUES (DEFAULT); 32INSERT INTO t2 VALUES (DEFAULT); 33INSERT INTO t2 VALUES (DEFAULT); 34INSERT INTO t2 VALUES (DEFAULT); 35INSERT INTO t2 VALUES (DEFAULT); 36INSERT INTO t2 VALUES (DEFAULT); 37INSERT INTO t2 VALUES (DEFAULT); 38INSERT INTO t2 VALUES (DEFAULT); 39INSERT INTO t2 VALUES (DEFAULT); 40INSERT INTO t2 VALUES (DEFAULT); 41INSERT INTO t2 VALUES (DEFAULT); 42INSERT INTO t2 VALUES (DEFAULT); 43INSERT INTO t2 VALUES (DEFAULT); 44INSERT INTO t2 VALUES (DEFAULT); 45INSERT INTO t2 VALUES (DEFAULT); 46INSERT INTO t2 VALUES (DEFAULT); 47INSERT INTO t2 VALUES (DEFAULT); 48INSERT INTO t2 VALUES (DEFAULT); 49INSERT INTO t2 VALUES (DEFAULT); 50INSERT INTO t2 VALUES (DEFAULT); 51INSERT INTO t2 VALUES (DEFAULT); 52INSERT INTO t2 VALUES (DEFAULT); 53INSERT INTO t2 VALUES (DEFAULT); 54INSERT INTO t2 VALUES (DEFAULT); 55INSERT INTO t2 VALUES (DEFAULT); 56INSERT INTO t2 VALUES (DEFAULT); 57INSERT INTO t2 VALUES (DEFAULT); 58INSERT INTO t2 VALUES (DEFAULT); 59INSERT INTO t2 VALUES (DEFAULT); 60INSERT INTO t2 VALUES (DEFAULT); 61INSERT INTO t2 VALUES (DEFAULT); 62INSERT INTO t2 VALUES (DEFAULT); 63INSERT INTO t2 VALUES (DEFAULT); 64INSERT INTO t2 VALUES (DEFAULT); 65INSERT INTO t2 VALUES (DEFAULT); 66INSERT INTO t2 VALUES (DEFAULT); 67INSERT INTO t2 VALUES (DEFAULT); 68INSERT INTO t2 VALUES (DEFAULT); 69INSERT INTO t2 VALUES (DEFAULT); 70INSERT INTO t2 VALUES (DEFAULT); 71INSERT INTO t2 VALUES (DEFAULT); 72INSERT INTO t2 VALUES (DEFAULT); 73INSERT INTO t2 VALUES (DEFAULT); 74INSERT INTO t2 VALUES (DEFAULT); 75INSERT INTO t2 VALUES (DEFAULT); 76INSERT INTO t2 VALUES (DEFAULT); 77INSERT INTO t2 VALUES (DEFAULT); 78INSERT INTO t2 VALUES (DEFAULT); 79INSERT INTO t2 VALUES (DEFAULT); 80INSERT INTO t2 VALUES (DEFAULT); 81INSERT INTO t2 VALUES (DEFAULT); 82INSERT INTO t2 VALUES (DEFAULT); 83INSERT INTO t2 VALUES (DEFAULT); 84INSERT INTO t2 VALUES (DEFAULT); 85INSERT INTO t2 VALUES (DEFAULT); 86INSERT INTO t2 VALUES (DEFAULT); 87INSERT INTO t2 VALUES (DEFAULT); 88INSERT INTO t2 VALUES (DEFAULT); 89INSERT INTO t2 VALUES (DEFAULT); 90INSERT INTO t2 VALUES (DEFAULT); 91INSERT INTO t2 VALUES (DEFAULT); 92INSERT INTO t2 VALUES (DEFAULT); 93INSERT INTO t2 VALUES (DEFAULT); 94INSERT INTO t2 VALUES (DEFAULT); 95SELECT COUNT(*) = 64 FROM t2; 96COUNT(*) = 64 971 98SET wsrep_sync_wait=0; 99SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user'; 100COUNT(*) = @@wsrep_slave_threads + 1 1011 102SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%'; 103COUNT(*) = 1 1041 105SET GLOBAL wsrep_slave_threads = 5; 106SET GLOBAL wsrep_slave_threads = 1; 107Shutting down server ... 108SET wsrep_sync_wait=0; 109show status like 'wsrep_cluster_size'; 110Variable_name Value 111wsrep_cluster_size 1 112SET GLOBAL wsrep_slave_threads = 6; 113SET GLOBAL wsrep_slave_threads = 1; 114SET GLOBAL wsrep_cluster_address=''; 115SET GLOBAL wsrep_cluster_address='gcomm://'; 116SET GLOBAL wsrep_slave_threads = 10; 117# restart 118SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user'; 119COUNT(*) = @@wsrep_slave_threads + 1 1201 121SET GLOBAL wsrep_slave_threads = 1; 122SET GLOBAL wsrep_slave_threads = 1; 123INSERT INTO t2 VALUES (DEFAULT); 124INSERT INTO t2 VALUES (DEFAULT); 125INSERT INTO t2 VALUES (DEFAULT); 126INSERT INTO t2 VALUES (DEFAULT); 127INSERT INTO t2 VALUES (DEFAULT); 128INSERT INTO t2 VALUES (DEFAULT); 129INSERT INTO t2 VALUES (DEFAULT); 130INSERT INTO t2 VALUES (DEFAULT); 131INSERT INTO t2 VALUES (DEFAULT); 132INSERT INTO t2 VALUES (DEFAULT); 133INSERT INTO t2 VALUES (DEFAULT); 134INSERT INTO t2 VALUES (DEFAULT); 135INSERT INTO t2 VALUES (DEFAULT); 136INSERT INTO t2 VALUES (DEFAULT); 137INSERT INTO t2 VALUES (DEFAULT); 138INSERT INTO t2 VALUES (DEFAULT); 139INSERT INTO t2 VALUES (DEFAULT); 140INSERT INTO t2 VALUES (DEFAULT); 141INSERT INTO t2 VALUES (DEFAULT); 142INSERT INTO t2 VALUES (DEFAULT); 143INSERT INTO t2 VALUES (DEFAULT); 144INSERT INTO t2 VALUES (DEFAULT); 145INSERT INTO t2 VALUES (DEFAULT); 146INSERT INTO t2 VALUES (DEFAULT); 147INSERT INTO t2 VALUES (DEFAULT); 148INSERT INTO t2 VALUES (DEFAULT); 149INSERT INTO t2 VALUES (DEFAULT); 150INSERT INTO t2 VALUES (DEFAULT); 151INSERT INTO t2 VALUES (DEFAULT); 152INSERT INTO t2 VALUES (DEFAULT); 153INSERT INTO t2 VALUES (DEFAULT); 154INSERT INTO t2 VALUES (DEFAULT); 155INSERT INTO t2 VALUES (DEFAULT); 156INSERT INTO t2 VALUES (DEFAULT); 157INSERT INTO t2 VALUES (DEFAULT); 158INSERT INTO t2 VALUES (DEFAULT); 159INSERT INTO t2 VALUES (DEFAULT); 160INSERT INTO t2 VALUES (DEFAULT); 161INSERT INTO t2 VALUES (DEFAULT); 162INSERT INTO t2 VALUES (DEFAULT); 163INSERT INTO t2 VALUES (DEFAULT); 164INSERT INTO t2 VALUES (DEFAULT); 165INSERT INTO t2 VALUES (DEFAULT); 166INSERT INTO t2 VALUES (DEFAULT); 167INSERT INTO t2 VALUES (DEFAULT); 168INSERT INTO t2 VALUES (DEFAULT); 169INSERT INTO t2 VALUES (DEFAULT); 170INSERT INTO t2 VALUES (DEFAULT); 171INSERT INTO t2 VALUES (DEFAULT); 172INSERT INTO t2 VALUES (DEFAULT); 173INSERT INTO t2 VALUES (DEFAULT); 174INSERT INTO t2 VALUES (DEFAULT); 175INSERT INTO t2 VALUES (DEFAULT); 176INSERT INTO t2 VALUES (DEFAULT); 177INSERT INTO t2 VALUES (DEFAULT); 178INSERT INTO t2 VALUES (DEFAULT); 179INSERT INTO t2 VALUES (DEFAULT); 180INSERT INTO t2 VALUES (DEFAULT); 181INSERT INTO t2 VALUES (DEFAULT); 182INSERT INTO t2 VALUES (DEFAULT); 183INSERT INTO t2 VALUES (DEFAULT); 184INSERT INTO t2 VALUES (DEFAULT); 185INSERT INTO t2 VALUES (DEFAULT); 186INSERT INTO t2 VALUES (DEFAULT); 187INSERT INTO t2 VALUES (DEFAULT); 188INSERT INTO t2 VALUES (DEFAULT); 189INSERT INTO t2 VALUES (DEFAULT); 190INSERT INTO t2 VALUES (DEFAULT); 191INSERT INTO t2 VALUES (DEFAULT); 192INSERT INTO t2 VALUES (DEFAULT); 193INSERT INTO t2 VALUES (DEFAULT); 194INSERT INTO t2 VALUES (DEFAULT); 195INSERT INTO t2 VALUES (DEFAULT); 196INSERT INTO t2 VALUES (DEFAULT); 197INSERT INTO t2 VALUES (DEFAULT); 198INSERT INTO t2 VALUES (DEFAULT); 199INSERT INTO t2 VALUES (DEFAULT); 200INSERT INTO t2 VALUES (DEFAULT); 201INSERT INTO t2 VALUES (DEFAULT); 202INSERT INTO t2 VALUES (DEFAULT); 203INSERT INTO t2 VALUES (DEFAULT); 204INSERT INTO t2 VALUES (DEFAULT); 205INSERT INTO t2 VALUES (DEFAULT); 206INSERT INTO t2 VALUES (DEFAULT); 207INSERT INTO t2 VALUES (DEFAULT); 208INSERT INTO t2 VALUES (DEFAULT); 209INSERT INTO t2 VALUES (DEFAULT); 210INSERT INTO t2 VALUES (DEFAULT); 211INSERT INTO t2 VALUES (DEFAULT); 212INSERT INTO t2 VALUES (DEFAULT); 213INSERT INTO t2 VALUES (DEFAULT); 214INSERT INTO t2 VALUES (DEFAULT); 215INSERT INTO t2 VALUES (DEFAULT); 216INSERT INTO t2 VALUES (DEFAULT); 217INSERT INTO t2 VALUES (DEFAULT); 218INSERT INTO t2 VALUES (DEFAULT); 219INSERT INTO t2 VALUES (DEFAULT); 220INSERT INTO t2 VALUES (DEFAULT); 221INSERT INTO t2 VALUES (DEFAULT); 222INSERT INTO t2 VALUES (DEFAULT); 223INSERT INTO t2 VALUES (DEFAULT); 224INSERT INTO t2 VALUES (DEFAULT); 225INSERT INTO t2 VALUES (DEFAULT); 226INSERT INTO t2 VALUES (DEFAULT); 227INSERT INTO t2 VALUES (DEFAULT); 228INSERT INTO t2 VALUES (DEFAULT); 229INSERT INTO t2 VALUES (DEFAULT); 230INSERT INTO t2 VALUES (DEFAULT); 231INSERT INTO t2 VALUES (DEFAULT); 232INSERT INTO t2 VALUES (DEFAULT); 233INSERT INTO t2 VALUES (DEFAULT); 234INSERT INTO t2 VALUES (DEFAULT); 235INSERT INTO t2 VALUES (DEFAULT); 236INSERT INTO t2 VALUES (DEFAULT); 237INSERT INTO t2 VALUES (DEFAULT); 238INSERT INTO t2 VALUES (DEFAULT); 239INSERT INTO t2 VALUES (DEFAULT); 240INSERT INTO t2 VALUES (DEFAULT); 241INSERT INTO t2 VALUES (DEFAULT); 242INSERT INTO t2 VALUES (DEFAULT); 243INSERT INTO t2 VALUES (DEFAULT); 244INSERT INTO t2 VALUES (DEFAULT); 245INSERT INTO t2 VALUES (DEFAULT); 246INSERT INTO t2 VALUES (DEFAULT); 247INSERT INTO t2 VALUES (DEFAULT); 248INSERT INTO t2 VALUES (DEFAULT); 249INSERT INTO t2 VALUES (DEFAULT); 250INSERT INTO t2 VALUES (DEFAULT); 251DROP TABLE t1; 252DROP TABLE t2; 253