MariaDB innodb_buffer_pool_size

1 개요

MariaDB innodb_buffer_pool_size

• 메모리의 80%로 설정하는 것이 좋다.
• 기본값은 134217728 (128MB)

Console

Copy

MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| innodb_buffer_pool_size | 268435456 |
+-------------------------+-----------+
1 row in set (0.001 sec)

→ 268435456 바이트 = 256 MB

2 변경

/etc/mysql/mariadb.conf.d/myserver.cnf

ini

Copy

[mariadb]
innodb_buffer_pool_size=512M

Console

Copy

MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| innodb_buffer_pool_size | 536870912 |
+-------------------------+-----------+
1 row in set (0.002 sec)

3 같이 보기

• MariaDB 설정
• MariaDB innodb_buffer_pool_chunk_size
• MariaDB innodb_buffer_pool_instances
• SHOW VARIABLES

4 참고

• https://stackoverflow.com/questions/13769598/where-else-can-the-variable-innodb-buffer-pool-size-be-accessed-besides-my-cnf