Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.18
-
Linux 4.19.0-6-amd64 #1 SMP Debian 4.19.67-2+deb10u2 (2019-11-11) x86_64 GNU/Linux
Description
Values are good with the following commands :
MariaDB [nextcloud]> SHOW GLOBAL VARIABLES LIKE "innodb_buffer_pool_chunk_size";
innodb_buffer_pool_chunk_size | 805306368 |
MariaDB [nextcloud]> SHOW GLOBAL VARIABLES LIKE "innodb_buffer_pool_size";
innodb_buffer_pool_size | 6442450944 |
MariaDB [nextcloud]> SHOW GLOBAL VARIABLES LIKE "innodb_buffer_pool_instances";
innodb_buffer_pool_instances | 8 |
Values are not good when we check with the command "show engine innodb status\g" :
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6623854592
Dictionary memory allocated 403920
Buffer pool size 393216
Free buffers 342904
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 49152
Free buffers 42853
Database pages 12368
Old database pages 4581
The value of each instance is 49 MB instead of 768 MB
Attachments
Issue Links
- is blocked by
-
MDEV-29445 reorganise innodb buffer pool (and remove buffer pool chunks)
- Stalled