#At lp:maria based on revid:monty@askmonty.org-20100824173759-4bnhyfyddc0n4jbe 2914 Michael Widenius 2010-08-24 Increase some very old limits. This will give a smoother experience when using the Aria engine by those that are using default limits without still causing a notable problem for desktop users. modified: include/my_global.h storage/maria/ha_maria.cc === modified file 'include/my_global.h' --- a/include/my_global.h 2010-08-02 09:01:24 +0000 +++ b/include/my_global.h 2010-08-24 18:15:05 +0000 @@ -800,9 +800,9 @@ typedef SOCKET_SIZE_TYPE size_socket; /* get memory in huncs */ #define ONCE_ALLOC_INIT (uint) (4096-MALLOC_OVERHEAD) /* Typical record cash */ -#define RECORD_CACHE_SIZE (uint) (64*1024-MALLOC_OVERHEAD) +#define RECORD_CACHE_SIZE (uint) (128*1024-MALLOC_OVERHEAD) /* Typical key cash */ -#define KEY_CACHE_SIZE (uint) (8*1024*1024-MALLOC_OVERHEAD) +#define KEY_CACHE_SIZE (uint) (128L*1024L*1024L-MALLOC_OVERHEAD) /* Default size of a key cache block */ #define KEY_CACHE_BLOCK_SIZE (uint) 1024 === modified file 'storage/maria/ha_maria.cc' --- a/storage/maria/ha_maria.cc 2010-08-23 09:52:57 +0000 +++ b/storage/maria/ha_maria.cc 2010-08-24 18:15:05 +0000 @@ -212,7 +212,7 @@ static MYSQL_THDVAR_ULONG(repair_threads static MYSQL_THDVAR_ULONG(sort_buffer_size, PLUGIN_VAR_RQCMDARG, "The buffer that is allocated when sorting the index when doing a " "REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.", - 0, 0, 8192*1024, 4, ~0L, 1); + 0, 0, 128L*1024L*1024L, 4, ~0L, 1); static MYSQL_THDVAR_ENUM(stats_method, PLUGIN_VAR_RQCMDARG, "Specifies how maria index statistics collection code should treat "