connection node_2;
connection node_1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER, f2 VARCHAR(10 )) ENGINE=InnoDB;
SET SESSION wsrep_trx_fragment_size = 1 ;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
INSERT INTO t1 VALUES (1 , 'a' );
INSERT INTO t1 VALUES (2 , 'a' );
INSERT INTO t1 VALUES (3 , 'a' );
INSERT INTO t1 VALUES (4 , 'a' );
INSERT INTO t1 VALUES (5 , 'a' );
connection node_2;
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
connection node_1;
INSERT INTO t1 VALUES (11 , 'b' );
INSERT INTO t1 VALUES (12 , 'b' );
INSERT INTO t1 VALUES (13 , 'b' );
INSERT INTO t1 VALUES (14 , 'b' );
INSERT INTO t1 VALUES (15 , 'b' );
connection node_2;
connection node_1;
ROLLBACK;
connection node_2;
connection node_1;
START TRANSACTION;
INSERT INTO t1 VALUES (1 , 'a' );
INSERT INTO t1 VALUES (2 , 'a' );
INSERT INTO t1 VALUES (3 , 'a' );
INSERT INTO t1 VALUES (4 , 'a' );
INSERT INTO t1 VALUES (5 , 'a' );
INSERT INTO t1 VALUES (11 , 'b' );
INSERT INTO t1 VALUES (12 , 'b' );
INSERT INTO t1 VALUES (13 , 'b' );
INSERT INTO t1 VALUES (14 , 'b' );
INSERT INTO t1 VALUES (15 , 'b' );
connection node_2;
connection node_1;
COMMIT;
connection node_2;
connection node_1;
DROP TABLE t1;
Messung V0.5 in Prozent C=0 H=100 G=70
¤ Dauer der Verarbeitung: 0.10 Sekunden
(vorverarbeitet am 2026-10-08)
¤
*© Formatika GbR, Deutschland