[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;