1** Setup ** 2 3SET @start_value = @@global.query_prealloc_size; 4CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY, val TEXT(200)); 5INSERT INTO t1 VALUES(NULL,'a'); 6INSERT INTO t1 VALUES(NULL,'b'); 7INSERT INTO t1 VALUES(NULL,'c'); 8INSERT INTO t1 VALUES(NULL,'d'); 9SELECT * FROM t1 ORDER BY val; 10id val 111 a 122 b 133 c 144 d 15SET SESSION query_prealloc_size = 8192; 16'#----------------------------FN_DYNVARS_137_05-----------------#' 17SET GLOBAL query_prealloc_size = 8192; 18connect con_int1,localhost,root,,; 19connection con_int1; 20SELECT @@SESSION.query_prealloc_size; 21@@SESSION.query_prealloc_size 228192 23Expected Value : 8192; 24SET SESSION query_prealloc_size = 16384; 25connect con_int2,localhost,root,,; 26connection con_int2; 27SELECT @@SESSION.query_prealloc_size; 28@@SESSION.query_prealloc_size 298192 30Expected Value : 8192; 31SET SESSION query_prealloc_size = 8192; 32connection con_int1; 33SELECT @@SESSION.query_prealloc_size; 34@@SESSION.query_prealloc_size 3516384 36Expected Value : 16384; 37connection con_int2; 38SELECT @@SESSION.query_prealloc_size; 39@@SESSION.query_prealloc_size 408192 41Expected Value : 8192; 42SELECT @@GLOBAL.query_prealloc_size; 43@@GLOBAL.query_prealloc_size 448192 45Expected Value : 8192; 46connection default; 47disconnect con_int1; 48disconnect con_int2; 49DROP TABLE t1; 50SET @@global.query_prealloc_size = @start_value; 51