Friday, August 03, 2007

MySQL Performance Tuning Tip

Set these values in my.cnf:

innodb_buffer_pool_size=128M
key_buffer_size=128M
query_cache_size=32M

I've seen big performance boosts by setting these values.