MySQL - Joins performed without indexes

[melbo]

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]

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]

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

 

[CTXMedia]

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.

 

[Amin Sabet]

I'm looking at this issue as well. Any reason to set join_buffer_size to 1M or 2M as opposed to 64K or 256K? The number of joins without indexes seems to be the same regardless of setting, and the documentation says "Memory allocation time can cause substantial performance drops if the global size is larger than needed by most queries that use it". Source: https://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_join_buffer_size