⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
t
/
View File Name :
variables-big.test
# 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;