• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

MySQL - Joins performed without indexes

melbo

Well-known member
#1
Is this anything I can tune?
[!!] Joins performed without indexes: 24403

No matter how much I've increased join_buffer_size, it still suggests larger with no noticeable improvment- I'm back down at 1M.
Also,
Is this recommendation possible with XF?
Adjust your join queries to always utilize indexes
Thanks
 

Adam Howard

Well-known member
#2
Is this anything I can tune?
[!!] Joins performed without indexes: 24403

No matter how much I've increased join_buffer_size, it still suggests larger with no noticeable improvment- I'm back down at 1M.
Also,
Is this recommendation possible with XF?
Adjust your join queries to always utilize indexes
Thanks
OK, I'll bite... What is suggesting you to increase that?

Have you tried rebooting mysql and php so that the new stats will apply?
 

melbo

Well-known member
#3
mysqltuner recommends increasing that value. I increase it to extremes (256M) and mysqltuner still recommends increasing join_buffer_size >**M

Affirmative on the restarts of both MySQL and Apache after changes are made.

Thanks
 

CyclingTribe

Well-known member
#4
Leave it at 1M or 2M - there are always joins without indexes and mysqltuner always recommends increasing it. It's not causing you any problems, not slowing you down, and is generally within the code/queries of the application itself that this has to be changed (and not something you can easily debug/modify yourself).

Set it and forget it. :D
 

Amin Sabet

Well-known member
#5