2013. 7. 3. 09:58

[MySQL] db cache 사용방법

[mysqld]

max_connections=500

join_buffer_size = 2M

tmp_table_size = 24M

max_heap_table_size = 24M

query_cache_size = 256M

key_buffer=256M

key_buffer_size = 1332M

thread_cache_size = 4

table_cache = 500

table_open_cache = 96

innodb_buffer_pool_size = 27M

slow_query_log

local-infile=0



쿼리 캐쉬 관련 자료 :

http://forums.cpanel.net/f189/best-optimization-my-cnf-269391.html