Announcement

Announcement Module
Collapse
No announcement yet.

join_buffer_size

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • join_buffer_size

    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.
Working...
X