Home » Performance » MySQL » join_buffer_size
join_buffer_size [message #3220] Wed, 25 June 2008 12:08
howachen  is currently offline howachen
Messages: 7
Registered: February 2007
Junior Member
Hello,

1. Is it true that if my table join is using index, then this value is meaningless?

2. On the other hand, what value should I set? Assuming I have 4GB of main memory and do a lot of large table join.

3. The mysql tunning script (www.day32.com/MySQL) said more than 4MB is not advised, is it too conservative?


Many Thanks.
Previous Topic:More than 400 concurrent small queries
Next Topic:Optimize ORDER BY
Goto Forum:
  



Current Time: Sun Oct 12 20:02:46 EDT 2008

Total time taken to generate the page: 0.00888 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge