diff options
| author | Monty <monty@mariadb.org> | 2017-11-01 20:28:36 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2017-11-02 20:37:25 +0200 |
| commit | 9ec19b9b41804d8d4491f0f58ac06ae417e02ffa (patch) | |
| tree | 91b175f8799056ae5bf1eed61d3917e374e7903f /sql/sql_const.h | |
| parent | 2ec7b870531d70f3c7686af2d6bc2c33e7c23bc7 (diff) | |
| download | mariadb-git-9ec19b9b41804d8d4491f0f58ac06ae417e02ffa.tar.gz | |
Reducing memory when using information schema
The background is that one user had a lot of views and using some complex
queries on information schema temporary memory of more than 2G was used.
- Added new element 'total_alloc' to MEM_ROOT for easier debugging.
- Added MAX_MEMORY_USED to information_schema.processlist.
- Added new status variable "Memory_used_initial" that shows how much MariaDB
uses at startup. This gives the base value for "Memory_used".
- Reuse memory continuously for information schema queries instead of
only freeing memory at query end.
Other things
- Removed some not needed set_notnull() calls for not null columns.
Diffstat (limited to 'sql/sql_const.h')
| -rw-r--r-- | sql/sql_const.h | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/sql_const.h b/sql/sql_const.h index a5756aa1f39..007b7faeebb 100644 --- a/sql/sql_const.h +++ b/sql/sql_const.h @@ -175,6 +175,11 @@ #define TABLE_ALLOC_BLOCK_SIZE 1024 #define WARN_ALLOC_BLOCK_SIZE 2048 #define WARN_ALLOC_PREALLOC_SIZE 1024 +/* + Note that if we are using 32K or less, then TCmalloc will use a local + heap without locks! +*/ +#define SHOW_ALLOC_BLOCK_SIZE (32768-MALLOC_OVERHEAD) /* The following parameters is to decide when to use an extra cache to |