| Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 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 : OFF Directory : /www/server/mysql/mysql-test/r/ |
Upload File : |
'#________________________VAR_05_table_definition_cache__________________#' echo '##' --echo '#---------------------WL6372_VAR_5_01----------------------#' #################################################################### # Checking default value # #################################################################### SELECT COUNT(@@GLOBAL.table_definition_cache) 1 Expected SET @@GLOBAL.table_definition_cache=DEFAULT; SELECT IF (@@open_files_limit < 5000, 1400, @@GLOBAL.table_definition_cache); IF (@@open_files_limit < 5000, 1400, @@GLOBAL.table_definition_cache) 1400 1400 Expected '#---------------------WL6372_VAR_5_02----------------------#' # Restart server with table_definition_cache 1 SELECT @@GLOBAL.table_definition_cache; @@GLOBAL.table_definition_cache 2000 2000 Expected SET @@GLOBAL.table_definition_cache=DEFAULT; SELECT IF (@@open_files_limit < 5000, 1400, @@GLOBAL.table_definition_cache); IF (@@open_files_limit < 5000, 1400, @@GLOBAL.table_definition_cache) 1400 1400 Expected '#---------------------WL6372_VAR_5_03----------------------#' SET @@local.table_definition_cache=1; ERROR HY000: Variable 'table_definition_cache' is a GLOBAL variable and should be set with SET GLOBAL Expected error 'Global variable' SET @@session.table_definition_cache=1; ERROR HY000: Variable 'table_definition_cache' is a GLOBAL variable and should be set with SET GLOBAL Expected error 'Global variable' SET @@GLOBAL.table_definition_cache=1; SET @@GLOBAL.table_definition_cache=DEFAULT; SELECT IF (@@open_files_limit < 5000, 1400, @@GLOBAL.table_definition_cache); IF (@@open_files_limit < 5000, 1400, @@GLOBAL.table_definition_cache) 1400 1400 Expected '#---------------------WL6372_VAR_5_04----------------------#' SELECT @@GLOBAL.table_definition_cache = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='table_definition_cache'; @@GLOBAL.table_definition_cache = VARIABLE_VALUE 1 1 Expected SELECT COUNT(@@GLOBAL.table_definition_cache); COUNT(@@GLOBAL.table_definition_cache) 1 1 Expected SELECT COUNT(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='table_definition_cache'; COUNT(VARIABLE_VALUE) 1 1 Expected '#---------------------WL6372_VAR_5_05----------------------#' SELECT @@table_definition_cache = @@GLOBAL.table_definition_cache; @@table_definition_cache = @@GLOBAL.table_definition_cache 1 1 Expected SELECT COUNT(@@local.table_definition_cache); ERROR HY000: Variable 'table_definition_cache' is a GLOBAL variable Expected error 'Variable is a GLOBAL variable' SELECT COUNT(@@SESSION.table_definition_cache); ERROR HY000: Variable 'table_definition_cache' is a GLOBAL variable Expected error 'Variable is a GLOBAL variable' SELECT COUNT(@@GLOBAL.table_definition_cache); COUNT(@@GLOBAL.table_definition_cache) 1 1 Expected SELECT table_definition_cache = @@SESSION.table_definition_cache; ERROR 42S22: Unknown column 'table_definition_cache' in 'field list' Expected error 'Unknown column table_definition_cache in field list' '#---------------------WL6372_VAR_5_06----------------------#' Check the size of the vardir The output size is in unit blocks TRUE TRUE Expected '#---------------------WL6372_VAR_5_07----------------------#' flush tables; flush status; set @Open_table_definitions = (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions'); set @Opened_table_definitions = (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions'); # create 2 tables DROP TABLE IF EXISTS tab1; DROP TABLE IF EXISTS tab2; =============== create table & Index =============== CREATE TABLE tab1 (col_1 text(10)) ENGINE=INNODB ; =============== create table & Index =============== CREATE TABLE tab2 (col_1 text(10)) ENGINE=INNODB ; select (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions; (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions 1 1 Expected select (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 2; (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 2 1 1 Expected # open two tables select 1 from tab1; 1 1 Expected select (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions + 1; (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions + 1 1 1 Expected select (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 3; (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 3 1 1 Expected select 1 from tab2; 1 1 Expected select (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions + 2; (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions + 2 1 1 Expected select (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 4; (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 4 1 1 Expected DROP TABLE IF EXISTS tab1; select (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions + 1; (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions + 1 1 1 Expected select (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 4; (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 4 1 1 Expected DROP TABLE IF EXISTS tab2; select (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions; (select variable_value from information_schema.session_status where variable_name ='Open_table_definitions') = @Open_table_definitions 1 1 Expected select (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 4; (select variable_value from information_schema.session_status where variable_name ='Opened_table_definitions') = @Opened_table_definitions + 4 1 1 Expected #cleanup set @@GLOBAL.table_definition_cache=DEFAULT;