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

Discussion in 'Server Configuration and Hosting' started by melbo, Aug 2, 2012.

  1. melbo

    melbo Well-Known Member

    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.
    Is this recommendation possible with XF?
    Adjust your join queries to always utilize indexes
  2. Adam Howard

    Adam Howard Well-Known Member

    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?
  3. melbo

    melbo Well-Known Member

    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.

  4. CyclingTribe

    CyclingTribe Well-Known Member

    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
    melbo and Brent W like this.
  5. Amin Sabet

    Amin Sabet Well-Known Member

Share This Page