"MariaDB innodb buffer pool size"의 두 판 사이의 차이

2020년 4월 19일 (일) 15:56 기준 최신판

1 개요[ | ]

MariaDB innodb_buffer_pool_size

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

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

[mariadb]
innodb_buffer_pool_size=512M

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 같이 보기[ | ]

4 참고[ | ]

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

↑ https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/#xtradb-and-innodbinnodb-xtradb-storage-engine

[1] ttps://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/#xtradb-and-innodbinnodb-xtradb-storage-engine

[1]

@@ 1번째 줄: / 1번째 줄: @@
 ==개요==
+{{DISPLAYTITLE:MariaDB innodb_buffer_pool_size}}
 ;MariaDB innodb_buffer_pool_size
-* 메모리의 80%로 설정
+* 메모리의 80%로 설정하는 것이 좋다.<ref>https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/#xtradb-and-innodbinnodb-xtradb-storage-engine</ref>
+* 기본값은 134217728 (128MB)
 <source lang='console'>
 MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
@@ 12번째 줄: / 15번째 줄: @@
 </source>
 :→ 268435456 바이트 = 256 MB
+==변경==
+{{소스헤더|/etc/mysql/mariadb.conf.d/myserver.cnf}}
+<source lang='ini'>
+[mariadb]
+innodb_buffer_pool_size=512M
+</source>
+<source lang='console'>
+MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
++-------------------------+-----------+
+| Variable_name           | Value     |
++-------------------------+-----------+
+| innodb_buffer_pool_size | 536870912 |
++-------------------------+-----------+
+row in set (0.002 sec)
+</source>
 ==같이 보기==
 * [[MariaDB 설정]]
+* [[MariaDB innodb_buffer_pool_chunk_size]]
+* [[MariaDB innodb_buffer_pool_instances]]
+* [[SHOW VARIABLES]]
 ==참고==
 * https://stackoverflow.com/questions/13769598/where-else-can-the-variable-innodb-buffer-pool-size-be-accessed-besides-my-cnf
 [[분류: MariaDB]]