[MDEV-21203] Bad value for the variable "Buffer pool size" Created: 2019-12-03  Updated: 2023-04-14

Status: Open
Project: MariaDB Server
Component/s: Configuration, Storage Engine - InnoDB
Affects Version/s: 10.3.18
Fix Version/s: 10.3

Type: Bug Priority: Major
Reporter: Philippe Genonceaux Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: buffer, innodb, size
Environment:

Linux 4.19.0-6-amd64 #1 SMP Debian 4.19.67-2+deb10u2 (2019-11-11) x86_64 GNU/Linux


Issue Links:
Blocks
is blocked by MDEV-29445 reorganise innodb buffer pool (and re... Stalled

 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


Generated at Thu Feb 08 09:05:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.