Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/innodb_undo/r/

View File Name : trunc_multi_client_01.result

use test;
create table t1
(keyc int, c1 char(100), c2 char(100),
primary key(keyc)) engine = innodb;
create table t2
(keyc int, c1 char(100), c2 char(100),
primary key(keyc)) engine = innodb;
CREATE PROCEDURE populate_t1()
BEGIN
DECLARE i INT DEFAULT 1;
while (i <= 40000) DO
insert into t1 values (i, 'a', 'b');
SET i = i + 1;
END WHILE;
END |
CREATE PROCEDURE populate_t2()
BEGIN
DECLARE i INT DEFAULT 1;
while (i <= 40000) DO
insert into t2 values (i, 'a', 'b');
SET i = i + 1;
END WHILE;
END |
begin;
call populate_t1();
delete from t1 where keyc < 20000;
update t1 set c1 = 'mysql' where  keyc > 20000;
update t1 set c2 = 'oracle' where  keyc > 20000;
begin;
call populate_t2();
delete from t2 where keyc < 20000;
update t2 set c1 = 'mysql' where  keyc > 20000;
update t2 set c2 = 'oracle' where  keyc > 20000;
commit;
commit;
drop table t1, t2;
drop PROCEDURE populate_t1;
drop PROCEDURE populate_t2;
SET GLOBAL innodb_fast_shutdown=0;
# restart
Pattern "Truncating UNDO tablespace" found