Im trying to understand the buffer settings for MySQL 5.1
Default settings for the buffers im interested in is
key_buffer_size=384M
read_buffer_size=16M
read_rnd_buffer_size=16M
My question is to improve performance how should we be modifying these? In the past I lowered the values but logically that doesn't make sense to me.
Changed to
key_buffer_size=128M
read_buffer_size=1M
read_rnd_buffer_size=1M
Just curious if someone could explain this.
Thanks