| Server IP : 172.67.216.182 / Your IP : 172.70.188.60 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb_zip/r/ |
Upload File : |
set innodb_strict_mode=OFF; create procedure populate() begin declare i int default 1; while (i <= 5000) do insert into t1 values (i, 'a', 'b'); insert into t2 values (i, 'a', 'b'); insert into t3 values (i, 'a', 'b'); set i = i + 1; end while; end| create procedure populate_small() begin declare i int default 10001; while (i <= 12000) do insert into t1 values (i, 'c', 'd'); insert into t2 values (i, 'a', 'b'); insert into t3 values (i, 'a', 'b'); set i = i + 1; end while; end| set global innodb_file_per_table = 1; set global innodb_file_format = 'Antelope'; Warnings: Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html create table tNUMBER (i int, cNUMBER char(NUMBER), cNUMBER char(NUMBER), index cNUMBER_idx(cNUMBER)) engine=innodb row_format=compact key_block_size=NUMBER; Warnings: Warning NUMBER InnoDB: KEY_BLOCK_SIZE requires innodb_file_format > Antelope. Warning NUMBER InnoDB: ignoring KEY_BLOCK_SIZE=NUMBER. create table t2 (i int, c1 char(100), c2 char(100), index c1_idx(c1)) engine=innodb row_format=compact key_block_size=16; Warnings: Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_format > Antelope. Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16. create temporary table t3 (i int, c1 char(100), c2 char(100), index c1_idx(c1)) engine=innodb row_format=compact key_block_size=16; Warnings: Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_format > Antelope. Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16. select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 0 select count(*) from t3; count(*) 0 begin; call populate(); commit; select count(*) from t1; count(*) 5000 select count(*) from t2; count(*) 5000 select count(*) from t3; count(*) 5000 truncate table t1; select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 5000 select count(*) from t3; count(*) 5000 call populate_small(); select count(*) from t1; count(*) 2000 select count(*) from t2; count(*) 7000 select count(*) from t3; count(*) 7000 truncate table t2; truncate table t3; select count(*) from t1; count(*) 2000 select count(*) from t2; count(*) 0 select count(*) from t3; count(*) 0 call populate_small(); select count(*) from t1; count(*) 4000 select count(*) from t2; count(*) 2000 select count(*) from t3; count(*) 2000 drop table t1; drop table t2; drop table t3; drop procedure populate; drop procedure populate_small; set global innodb_file_format = Barracuda; Warnings: Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html set global innodb_file_per_table = 1; set innodb_strict_mode=OFF; create procedure populate() begin declare i int default 1; while (i <= 5000) do insert into t1 values (i, 'a', 'b'); insert into t2 values (i, 'a', 'b'); insert into t3 values (i, 'a', 'b'); set i = i + 1; end while; end| create procedure populate_small() begin declare i int default 10001; while (i <= 12000) do insert into t1 values (i, 'c', 'd'); insert into t2 values (i, 'a', 'b'); insert into t3 values (i, 'a', 'b'); set i = i + 1; end while; end| set global innodb_file_per_table = 1; set global innodb_file_format = 'Barracuda'; Warnings: Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html create table tNUMBER (i int, cNUMBER char(NUMBER), cNUMBER char(NUMBER), index cNUMBER_idx(cNUMBER)) engine=innodb row_format=compressed key_block_size=NUMBER; create table t2 (i int, c1 char(100), c2 char(100), index c1_idx(c1)) engine=innodb row_format=compressed key_block_size=16; create temporary table t3 (i int, c1 char(100), c2 char(100), index c1_idx(c1)) engine=innodb row_format=compressed key_block_size=16; select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 0 select count(*) from t3; count(*) 0 begin; call populate(); commit; select count(*) from t1; count(*) 5000 select count(*) from t2; count(*) 5000 select count(*) from t3; count(*) 5000 truncate table t1; select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 5000 select count(*) from t3; count(*) 5000 call populate_small(); select count(*) from t1; count(*) 2000 select count(*) from t2; count(*) 7000 select count(*) from t3; count(*) 7000 truncate table t2; truncate table t3; select count(*) from t1; count(*) 2000 select count(*) from t2; count(*) 0 select count(*) from t3; count(*) 0 call populate_small(); select count(*) from t1; count(*) 4000 select count(*) from t2; count(*) 2000 select count(*) from t3; count(*) 2000 drop table t1; drop table t2; drop table t3; drop procedure populate; drop procedure populate_small; set global innodb_file_format = Barracuda; Warnings: Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html set global innodb_file_per_table = 1; set innodb_strict_mode=OFF; create procedure populate() begin declare i int default 1; while (i <= 5000) do insert into t1 values (i, 'a', 'b'); insert into t2 values (i, 'a', 'b'); insert into t3 values (i, 'a', 'b'); set i = i + 1; end while; end| create procedure populate_small() begin declare i int default 10001; while (i <= 12000) do insert into t1 values (i, 'c', 'd'); insert into t2 values (i, 'a', 'b'); insert into t3 values (i, 'a', 'b'); set i = i + 1; end while; end| set global innodb_file_per_table = 0; set global innodb_file_format = 'Antelope'; Warnings: Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html create table tNUMBER (i int, cNUMBER char(NUMBER), cNUMBER char(NUMBER), index cNUMBER_idx(cNUMBER)) engine=innodb row_format=compact key_block_size=NUMBER; Warnings: Warning NUMBER InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table. Warning NUMBER InnoDB: KEY_BLOCK_SIZE requires innodb_file_format > Antelope. Warning NUMBER InnoDB: ignoring KEY_BLOCK_SIZE=NUMBER. create table t2 (i int, c1 char(100), c2 char(100), index c1_idx(c1)) engine=innodb row_format=compact key_block_size=16; Warnings: Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table. Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_format > Antelope. Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16. create temporary table t3 (i int, c1 char(100), c2 char(100), index c1_idx(c1)) engine=innodb row_format=compact key_block_size=16; Warnings: Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table. Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_format > Antelope. Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16. select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 0 select count(*) from t3; count(*) 0 begin; call populate(); commit; select count(*) from t1; count(*) 5000 select count(*) from t2; count(*) 5000 select count(*) from t3; count(*) 5000 truncate table t1; select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 5000 select count(*) from t3; count(*) 5000 call populate_small(); select count(*) from t1; count(*) 2000 select count(*) from t2; count(*) 7000 select count(*) from t3; count(*) 7000 truncate table t2; truncate table t3; select count(*) from t1; count(*) 2000 select count(*) from t2; count(*) 0 select count(*) from t3; count(*) 0 call populate_small(); select count(*) from t1; count(*) 4000 select count(*) from t2; count(*) 2000 select count(*) from t3; count(*) 2000 drop table t1; drop table t2; drop table t3; drop procedure populate; drop procedure populate_small; set global innodb_file_format = Barracuda; Warnings: Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html set global innodb_file_per_table = 1;