Member Avatar for c1ockwerk

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

  • 2 Contributors
  • 1 Reply
  • 97 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Taywin
Member Avatar for Taywin

You may need to read this for a bit more understanding on key_buffer. The article also suggested a way to check your DB status and optimize it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.