Select_full_join count at 21k (!!)

  • kuznicki

    (@kuznicki)


    19 years ago

    I was recently browsing the MySQL runtime information (I use PHPMyAdmin 2.7.0-pl2), and I noticed that the value for Select_full_join is 21k, which I understand is extremely, dangerously, server-crashingly high.

    I don’t know a whole lot about MySQL, however, so I don’t really know what to do about it. What might be the problem, and how could I fix it?

    I’ve also got a value of 13 for the Select_range_check, which I understand is also bad.

    The documentation says both of these values ought to be zero, but they say nothing about how to correct the problem, except that I should “carefully check the indexes of your tables.” Since I didn’t create the tables (WordPress did), here I am. What do I do?

  • The topic ‘Select_full_join count at 21k (!!)’ is closed to new replies.