MySQL Performance: MySQL => join_buffer

Members

Help

Home

Home » Performance » MySQL » join_buffer_size

Show: Today's Messages :: Show Polls :: Message Navigator

join_buffer_size [message #3220]

Wed, 25 June 2008 12:08

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.

Report message to a moderator

Previous Topic:	More than 400 concurrent small queries
Next Topic:	Optimize ORDER BY

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

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 ::.