MySQL Performance Blog
by Rafa
Couple of months ago there was a post by FreshBooks on getting great performance improvements by lowering table_cache variable. So I decided to investigate what is really happening here.
The "common sense" approach to tuning caches is to get them as large as you can if you have enough resources (such as memory). With MySQL common sense however does not always works - we've seen performance issues with large query_cache_size also sort_buffer_size and read_buffer_size may not give you better performance if you increase them. I found this also applies to some other buffers.
[read more...]
