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 : undo_space_id.result

# Stop DB server which was created by MTR default
# create bootstrap file
# Run the bootstrap command with 2 undo tablespaces
# Start the DB server with 2 undo tablespaces
# restart: --datadir=MYSQLD_DATADIR1 --innodb_undo_tablespaces=2
CREATE TABLE t1
(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 |
BEGIN;
CALL populate_t1();
DELETE FROM t1 WHERE keyc < 20000;
UPDATE t1 SET c1 = 'mysql' WHERE keyc > 20000;
UPDATE t1 SET c1 = 'oracle' WHERE keyc > 20000;
COMMIT;
DROP TABLE t1;
DROP PROCEDURE populate_t1;
# Read the file size of undo tablespace before truncation
SET GLOBAL innodb_fast_shutdown=0;
# restart: --innodb-page-size=page_size
# Read the file size of undo tablespace after truncation