mirror of
https://github.com/MariaDB/server.git
synced 2025-02-13 17:05:35 +01:00
58c56dd7f8
Problem appears to be that the function fsp_flags_try_adjust() is being unconditionally invoked on every .ibd file on startup. Based on performance investigation also the top function fsp_header_get_crypt_offset() needs to addressed. Ported implementation of fsp_header_get_encryption_offset() function from 10.2 to fsp_header_get_crypt_offset(). Introduced a new function fil_crypt_read_crypt_data() to read page 0 if it is not yet read. fil_crypt_find_space_to_rotate(): Now that page 0 for every .ibd file is not read on startup we need to check has page 0 read from space that we investigate for key rotation, if it is not read we read it. fil_space_crypt_get_status(): Now that page 0 for every .ibd file is not read on startup here also we need to read page 0 if it is not yet read it. This is needed as tests use IS query to wait until background encryption or decryption has finished and this function is used to produce results. fil_crypt_thread(): Add is_stopping condition for tablespace so that we do not rotate pages if usage of tablespace should be stopped. This was needed for failure seen on regression testing. fil_space_create: Remove page_0_crypt_read and extra unnecessary info output. fil_open_single_table_tablespace(): We call fsp_flags_try_adjust only when when no errors has happened and server was not started on read only mode and tablespace validation was requested or flags contain other table options except low order bits to FSP_FLAGS_POS_PAGE_SSIZE position. fil_space_t::page_0_crypt_read removed. Added test case innodb-first-page-read to test startup when encryption is on and when encryption is off to check that not for all tables page 0 is read on startup.
97 lines
5.2 KiB
Text
97 lines
5.2 KiB
Text
-- source include/have_innodb.inc
|
|
-- source include/have_file_key_management_plugin.inc
|
|
-- source include/not_embedded.inc
|
|
|
|
--disable_warnings
|
|
SET GLOBAL innodb_file_format = `Barracuda`;
|
|
SET GLOBAL innodb_file_per_table = ON;
|
|
--enable_warnings
|
|
|
|
create database innodb_test;
|
|
use innodb_test;
|
|
create table innodb_normal(c1 bigint not null, b char(200)) engine=innodb;
|
|
create table innodb_compact(c1 bigint not null, b char(200)) engine=innodb row_format=compact;
|
|
create table innodb_dynamic(c1 bigint not null, b char(200)) engine=innodb row_format=dynamic;
|
|
create table innodb_compressed(c1 bigint not null, b char(200)) engine=innodb row_format=compressed;
|
|
create table innodb_compressed1(c1 bigint not null, b char(200)) engine=innodb row_format=compressed key_block_size=1;
|
|
create table innodb_compressed2(c1 bigint not null, b char(200)) engine=innodb row_format=compressed key_block_size=2;
|
|
create table innodb_compressed4(c1 bigint not null, b char(200)) engine=innodb row_format=compressed key_block_size=4;
|
|
create table innodb_compressed8(c1 bigint not null, b char(200)) engine=innodb row_format=compressed key_block_size=8;
|
|
create table innodb_compressed16(c1 bigint not null, b char(200)) engine=innodb row_format=compressed key_block_size=16;
|
|
create table innodb_redundant(c1 bigint not null, b char(200)) engine=innodb row_format=redundant;
|
|
create table innodb_pagecomp(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes;
|
|
create table innodb_pagecomp1(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=1;
|
|
create table innodb_pagecomp2(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=2;
|
|
create table innodb_pagecomp3(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=3;
|
|
create table innodb_pagecomp4(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=4;
|
|
create table innodb_pagecomp5(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=5;
|
|
create table innodb_pagecomp6(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=6;
|
|
create table innodb_pagecomp7(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=7;
|
|
create table innodb_pagecomp8(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=8;
|
|
create table innodb_pagecomp9(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes page_compression_level=9;
|
|
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
eval create table innodb_datadir1(c1 bigint not null, b char(200)) engine=innodb DATA DIRECTORY='$MYSQL_TMP_DIR';
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
eval create table innodb_datadir2(c1 bigint not null, b char(200)) engine=innodb row_format=compressed DATA DIRECTORY='$MYSQL_TMP_DIR';
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
eval create table innodb_datadir3(c1 bigint not null, b char(200)) engine=innodb page_compressed=yes DATA DIRECTORY='$MYSQL_TMP_DIR';
|
|
|
|
begin;
|
|
insert into innodb_normal values (1,'secret');
|
|
insert into innodb_compact select * from innodb_normal;
|
|
insert into innodb_dynamic select * from innodb_normal;
|
|
insert into innodb_compressed select * from innodb_normal;
|
|
insert into innodb_compressed1 select * from innodb_normal;
|
|
insert into innodb_compressed2 select * from innodb_normal;
|
|
insert into innodb_compressed4 select * from innodb_normal;
|
|
insert into innodb_compressed8 select * from innodb_normal;
|
|
insert into innodb_compressed16 select * from innodb_normal;
|
|
insert into innodb_redundant select * from innodb_normal;
|
|
insert into innodb_pagecomp select * from innodb_normal;
|
|
insert into innodb_pagecomp1 select * from innodb_normal;
|
|
insert into innodb_pagecomp2 select * from innodb_normal;
|
|
insert into innodb_pagecomp3 select * from innodb_normal;
|
|
insert into innodb_pagecomp4 select * from innodb_normal;
|
|
insert into innodb_pagecomp5 select * from innodb_normal;
|
|
insert into innodb_pagecomp6 select * from innodb_normal;
|
|
insert into innodb_pagecomp7 select * from innodb_normal;
|
|
insert into innodb_pagecomp8 select * from innodb_normal;
|
|
insert into innodb_pagecomp9 select * from innodb_normal;
|
|
insert into innodb_datadir1 select * from innodb_normal;
|
|
insert into innodb_datadir2 select * from innodb_normal;
|
|
insert into innodb_datadir3 select * from innodb_normal;
|
|
commit;
|
|
|
|
--echo # Restart server and see how many page 0's are read
|
|
--source include/restart_mysqld.inc
|
|
|
|
--echo # result should be less than actual number of tables
|
|
--echo # i.e. < 23 + 3 = 26
|
|
show status like 'innodb_pages0_read%';
|
|
use innodb_test;
|
|
show status like 'innodb_pages0_read%';
|
|
use test;
|
|
show status like 'innodb_pages0_read%';
|
|
|
|
set global innodb_encrypt_tables=OFF;
|
|
|
|
--echo # wait until tables are decrypted
|
|
--let $wait_condition=SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
|
|
--source include/wait_condition.inc
|
|
|
|
show status like 'innodb_pages0_read%';
|
|
use innodb_test;
|
|
show status like 'innodb_pages0_read%';
|
|
use test;
|
|
|
|
--echo # restart and see number read page 0
|
|
-- source include/restart_mysqld.inc
|
|
|
|
show status like 'innodb_pages0_read%';
|
|
use innodb_test;
|
|
show status like 'innodb_pages0_read%';
|
|
use test;
|
|
|
|
drop database innodb_test;
|
|
show status like 'innodb_pages0_read%';
|