Hi, I run mysqltuner this morning and I got these warning: [!!] Key buffer size / total MyISAM indexes: 12.0G/23.2G [!!] Key buffer hit rate: 76.9% [!!] Query cache efficiency: 0.0% [!!] Temporary tables created on disk: 27% [!!] Table cache hit rate: 5%
And mysqltuner recommends to adjust these setting: key_buffer_size (> 23.2G) query_cache_limit (> 1M, or use smaller result sets) tmp_table_size (> 64M) max_heap_table_size (> 128M) table_cache (> ) My physical RAM is only 16Gb. I am afraid it will freezed the server if I set key_buffer_size (> 23.2G). Any suggestion to optimize it? Thanks for any response. sangprabv sangpr...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
