Skip to content

innodb_buffer_pool_size Calculation  #138

@bst-biwac

Description

@bst-biwac

Issue in ./help/performance/software.md

This statement is false

innodb_buffer_pool_size | 128MB |
Combined with the multiple pool instances described above, this means a default memory allocation of 1024MB. The total size is divided among all the buffer pools. For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1 GB.

According to https://dev.mysql.com/doc/refman/8.4/en/glossary.html#glos_buffer_pool
where it says

. The total memory size specified by innodb_buffer_pool_size is divided among all buffer pool instances

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    Status

    🆕 Ready for Grooming

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions