⚝
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
/
suite
/
sys_vars
/
r
/
View File Name :
parser_max_mem_size_64.result
# Display the DEFAULT value of parser_max_mem_size # The DEFAULT is determined by --maximum-parser-max-mem-size SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 50000000 SELECT @@global.parser_max_mem_size; @@global.parser_max_mem_size 50000000 SET @@session.parser_max_mem_size = DEFAULT; SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 50000000 # Change the value of parser_max_mem_size to a valid # value for SESSION Scope SET @@session.parser_max_mem_size = 500 * 1000 * 100; SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 50000000 # Change the value of the session parser_max_mem_size to a # value greater than --maximum-parser-max-mem-size SET session parser_max_mem_size = 1000 * 1000 * 100; SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 100000000 # Change the value of the global parser_max_mem_size to a # value greater than --maximum-parser-max-mem-size SET @@global.parser_max_mem_size = 1000 * 1000 * 100; SELECT @@global.parser_max_mem_size; @@global.parser_max_mem_size 100000000 # Change the value of parser_max_mem_size to an invalid value SET @@session.parser_max_mem_size= 'NOT_CHAR_TYPE'; ERROR 42000: Incorrect argument type to variable 'parser_max_mem_size' SET @@session.parser_max_mem_size = -10; Warnings: Warning 1292 Truncated incorrect parser_max_mem_size value: '-10' SET @@session.parser_max_mem_size = 0.5; ERROR 42000: Incorrect argument type to variable 'parser_max_mem_size' # Check if TRUE and FALSE values can be used on variable SET @@session.parser_max_mem_size = TRUE; Warnings: Warning 1292 Truncated incorrect parser_max_mem_size value: '1' SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 10000000 SET @@session.parser_max_mem_size = FALSE; Warnings: Warning 1292 Truncated incorrect parser_max_mem_size value: '0' SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 10000000 # Restore initial value SET @@session.parser_max_mem_size = DEFAULT; SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 100000000 # Creating a new user CREATE USER example; # example user sets 45000000 SET @@session.parser_max_mem_size = 45000000; # default sets global 40000000 SET @@global.parser_max_mem_size = 40000000; # example user sets 45000000 SET @@session.parser_max_mem_size = 45000000; Warnings: Warning 1292 Truncated incorrect parser_max_mem_size value: '45000000' SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 40000000 # example user sets DEFAULT, which is now 40000000 SET @@session.parser_max_mem_size = DEFAULT; SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 40000000 # disconnect # default sets sesion 45000000 SET @@session.parser_max_mem_size = 45000000; SELECT @@session.parser_max_mem_size; @@session.parser_max_mem_size 45000000 DROP USER example; SET @@global.parser_max_mem_size = DEFAULT; # END OF parser_max_mem_size TESTS SELECT @@global.parser_max_mem_size; @@global.parser_max_mem_size 18446744073709551615 # global default is now "infite", must reset it to silence mtr. SET @@global.parser_max_mem_size = 50000000; SELECT @@global.parser_max_mem_size; @@global.parser_max_mem_size 50000000