diff options
| author | monty@mashka.mysql.fi <> | 2003-10-11 22:00:24 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-10-11 22:00:24 +0300 |
| commit | c95d142f8f602b717c6c10d13e37b2b3ecf069d4 (patch) | |
| tree | 50a7bfd87153439907087d4b3529d622cfc75313 /mysql-test/r/variables.result | |
| parent | 9bba878b8c6b6abd9be97a9d5a6c89bda8762693 (diff) | |
| download | mariadb-git-c95d142f8f602b717c6c10d13e37b2b3ecf069d4.tar.gz | |
Add new user variables for tuning memory usage:
query_alloc_block_size, query_prealloc_size, range_alloc_block_size,transaction_alloc_block_size and transaction_prealloc_size
Add more checks for "out of memory" detection in range optimization
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 7c054f55acd..50e97120de6 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -171,6 +171,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; Variable 'big_tables' can't be set to the value of 'OFFF' set big_tables="OFFF"; |