�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2F'>suite</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Fbinlog_encryption%2F'>binlog_encryption</a>/</p><hr><h3>✏️ Editing: rpl_parallel_domain.result</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>include/master-slave.inc
[connection master]
connection server_2;
SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
SET GLOBAL slave_parallel_threads=10;
ERROR HY000: This operation cannot be performed as you have a running slave &#039;&#039;; run STOP SLAVE &#039;&#039; first
include/stop_slave.inc
SET GLOBAL slave_parallel_threads=10;
SELECT IF(COUNT(*) &lt; 10, &quot;OK&quot;, CONCAT(&quot;Found too many system user processes: &quot;, COUNT(*))) FROM information_schema.processlist WHERE user = &quot;system user&quot;;
IF(COUNT(*) &lt; 10, &quot;OK&quot;, CONCAT(&quot;Found too many system user processes: &quot;, COUNT(*)))
OK
CHANGE MASTER TO master_use_gtid=slave_pos;
include/start_slave.inc
SELECT IF(COUNT(*) &gt;= 10, &quot;OK&quot;, CONCAT(&quot;Found too few system user processes: &quot;, COUNT(*))) FROM information_schema.processlist WHERE user = &quot;system user&quot;;
IF(COUNT(*) &gt;= 10, &quot;OK&quot;, CONCAT(&quot;Found too few system user processes: &quot;, COUNT(*)))
OK
include/stop_slave.inc
SELECT IF(COUNT(*) &lt; 10, &quot;OK&quot;, CONCAT(&quot;Found too many system user processes: &quot;, COUNT(*))) FROM information_schema.processlist WHERE user = &quot;system user&quot;;
IF(COUNT(*) &lt; 10, &quot;OK&quot;, CONCAT(&quot;Found too many system user processes: &quot;, COUNT(*)))
OK
include/start_slave.inc
SELECT IF(COUNT(*) &gt;= 10, &quot;OK&quot;, CONCAT(&quot;Found too few system user processes: &quot;, COUNT(*))) FROM information_schema.processlist WHERE user = &quot;system user&quot;;
IF(COUNT(*) &gt;= 10, &quot;OK&quot;, CONCAT(&quot;Found too few system user processes: &quot;, COUNT(*)))
OK
*** Test long-running query in domain 1 can run in parallel with short queries in domain 0 ***
connection server_1;
ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
CREATE TABLE t1 (a int PRIMARY KEY) ENGINE=MyISAM;
CREATE TABLE t2 (a int PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
INSERT INTO t2 VALUES (1);
connection server_2;
connect  con_temp1,127.0.0.1,root,,test,$SERVER_MYPORT_2,;
LOCK TABLE t1 WRITE;
connection server_1;
SET gtid_domain_id=1;
INSERT INTO t1 VALUES (2);
SET gtid_domain_id=0;
INSERT INTO t2 VALUES (2);
INSERT INTO t2 VALUES (3);
BEGIN;
INSERT INTO t2 VALUES (4);
INSERT INTO t2 VALUES (5);
COMMIT;
INSERT INTO t2 VALUES (6);
connection server_2;
SELECT * FROM t2 ORDER by a;
a
1
2
3
4
5
6
connection con_temp1;
SELECT * FROM t1;
a
1
UNLOCK TABLES;
connection server_2;
SELECT * FROM t1 ORDER BY a;
a
1
2
connection server_2;
include/stop_slave.inc
SET GLOBAL slave_parallel_threads=@old_parallel_threads;
include/start_slave.inc
connection server_1;
DROP TABLE t1,t2;
include/rpl_end.inc
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Fbinlog_encryption'>🔙 Back</a></p>