| Server IP : 185.86.78.101 / Your IP : 216.73.216.124 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/t/ |
Upload File : |
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc # # test variables big # --source include/big_test.inc # # Bug#27322 failure to allocate transaction_prealloc_size causes crash # # # Manual (5.1): # Platform Bit Size Range Default # 32/64 1024-128k 4096 # # Observation(mleich): # 1. - Linux 64 Bit, MySQL 64 Bit, 4 GiB RAM, 8 GiB swap # - SET SESSION transaction_prealloc_size=1099511627776; # SHOW PROCESSLIST; # Id User ... Info # <Id> root ... SHOW PROCESSLIST # SELECT @@session.transaction_prealloc_size; # @@session.transaction_prealloc_size # 1099511627776 # very short runtime in 5.0 # excessive resource consumption + long runtime in 5.1 and 6.0 # 2. - Win in VM, slightly older version of this test, MySQL 5.0 # - testcase timeout after 900s # analyze-timeout-mysqld.1.err : # Id User ... Time Info # 83 root ... 542 set session transaction_prealloc_size=1024*1024*1024*2 # 84 root ... 1 SHOW PROCESSLIST # # There is a significant probablitity that this tests fails with testcase # timeout if the testing box is not powerful enough. # SET @def_var= @@session.transaction_prealloc_size; --disable_warnings SET SESSION transaction_prealloc_size=1024*1024*1024*1; --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State> --sorted_result SHOW PROCESSLIST; SET SESSION transaction_prealloc_size=1024*1024*1024*2; --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State> --sorted_result SHOW PROCESSLIST; SET SESSION transaction_prealloc_size=1024*1024*1024*3; --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State> --sorted_result SHOW PROCESSLIST; SET SESSION transaction_prealloc_size=1024*1024*1024*4; --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State> --sorted_result SHOW PROCESSLIST; SET SESSION transaction_prealloc_size=1024*1024*1024*5; --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State> --sorted_result SHOW PROCESSLIST; --enable_warnings SET @@session.transaction_prealloc_size= @def_var;