diff options
| author | monty@mashka.mysql.fi <> | 2003-10-13 15:50:30 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-10-13 15:50:30 +0300 |
| commit | 461d1627b3323935345b13fe523f93dc74de9f36 (patch) | |
| tree | 9b5d0d5098c97ae49c22be860572ba78e7471faa /mysql-test/r/variables.result | |
| parent | c60a75e9ba08cd1937e73a42ca065b992a4f47d2 (diff) | |
| parent | c95d142f8f602b717c6c10d13e37b2b3ecf069d4 (diff) | |
| download | mariadb-git-461d1627b3323935345b13fe523f93dc74de9f36.tar.gz | |
merge with 4.0 for more memory allocation variables.
Diffstat (limited to 'mysql-test/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index ead09cc6ed7..30eb18dc7ed 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -163,6 +163,38 @@ set @@rand_seed1=10000000,@@rand_seed2=1000000; select ROUND(RAND(),5); ROUND(RAND(),5) 0.02887 +show variables like '%alloc%'; +Variable_name Value +query_alloc_block_size 8192 +query_prealloc_size 8192 +range_alloc_block_size 2048 +transaction_alloc_block_size 8192 +transaction_prealloc_size 4096 +set @@range_alloc_block_size=1024*16; +set @@query_alloc_block_size=1024*17+2; +set @@query_prealloc_size=1024*18; +set @@transaction_alloc_block_size=1024*20-1; +set @@transaction_prealloc_size=1024*21-1; +select @@query_alloc_block_size; +@@query_alloc_block_size +17408 +show variables like '%alloc%'; +Variable_name Value +query_alloc_block_size 17408 +query_prealloc_size 18432 +range_alloc_block_size 16384 +transaction_alloc_block_size 19456 +transaction_prealloc_size 20480 +set @@range_alloc_block_size=default; +set @@query_alloc_block_size=default, @@query_prealloc_size=default; +set transaction_alloc_block_size=default, @@transaction_prealloc_size=default; +show variables like '%alloc%'; +Variable_name Value +query_alloc_block_size 8192 +query_prealloc_size 8192 +range_alloc_block_size 2048 +transaction_alloc_block_size 8192 +transaction_prealloc_size 4096 set big_tables=OFFF; ERROR 42000: Variable 'big_tables' can't be set to the value of 'OFFF' set big_tables="OFFF"; |