Notice
Recent Posts
Recent Comments
Link
허허의 오늘은 뭐 먹지?
[mysql] innodb 튜닝 본문
mysql을 젤 처음 설치한 후 삐그덕거린다면 buffer size를 변경해보자.
-- innodb buffer size tunning
select 134217728*3; -- 402653184
show global variables like '%innodb_buffer_pool_size%';
show global variables like '%innodb_buffer_pool_chunk_size%';
show global variables like '%innodb_buffer_pool_instances%';
-- innodb buffer size 변경
SET GLOBAL innodb_buffer_pool_size=402653184;
반응형
'SW > 메모' 카테고리의 다른 글
| [mysql] Public key retrieval is not allowed (0) | 2023.05.13 |
|---|---|
| [mysql] timezone변경 (0) | 2023.05.13 |
| [GIT] git pull시 Enter passphrase for key 오류 (0) | 2023.04.28 |
| [python] python decorator (0) | 2023.02.04 |
| [Android] DataBinding 오류 찾기 (0) | 2022.07.23 |
'SW/메모' Related Articles
more
Comments