Debian Codegraph @

mysql-test/suite/innodb/r/lob_ibd_size.result

raw
1 CREATE TABLE `t`
2 (`id` INT NOT NULL AUTO_INCREMENT,
3 `b` LONGBLOB,
4 PRIMARY KEY(`id`)) ENGINE=InnoDB;
5 CREATE PROCEDURE p(p_num INT)
6 BEGIN
7 DECLARE v_i INT DEFAULT 0;
8 REPEAT
9 UPDATE t SET b:=REPEAT('a',FLOOR(1024*1024*4));
10 UPDATE t SET b:='';
11 SET v_i:=v_i+1;
12 UNTIL v_i>p_num END REPEAT;
13 END $
14 SET @b:=repeat('b',4*1024*1024);
15 INSERT INTO t(id,b) VALUES(1,@b);
16 START TRANSACTION;
17 CALL p(20);
18 COMMIT;
19 FLUSH TABLES `t` FOR EXPORT;
20 UNLOCK TABLES;
21 SET @fs1 = (SELECT file_size FROM information_schema.innodb_tablespaces
22 WHERE name = 'test/t');
23 START TRANSACTION;
24 CALL p(20);
25 COMMIT;
26 FLUSH TABLES `t` FOR EXPORT;
27 UNLOCK TABLES;
28 SET @fs2 = (SELECT file_size FROM information_schema.innodb_tablespaces
29 WHERE name = 'test/t');
30 SET @growing = (SELECT (@fs2 - @fs1));
31 SELECT @growing;
32 @growing
33 0
34 START TRANSACTION;
35 CALL p(20);
36 ROLLBACK;
37 FLUSH TABLES `t` FOR EXPORT;
38 UNLOCK TABLES;
39 SET @fs3 = (SELECT file_size FROM information_schema.innodb_tablespaces
40 WHERE name = 'test/t');
41 SET @growing = (SELECT (@fs3 - @fs2));
42 SELECT @growing;
43 @growing
44 0
45 DROP PROCEDURE p;
46 DROP TABLE t;