shamoon Posted October 25, 2007 Share Posted October 25, 2007 I'm a complete newb to optimizing MySQL and thank you to fenway for taking the time to respond to my other post. I'm working hard on tweaking my database and code. Select_full_join 1,544 The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables. That's the one thing I'm still trying to fix. Any easy way to track down which joins don't use indexes? Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/ Share on other sites More sharing options...
fenway Posted October 25, 2007 Share Posted October 25, 2007 Not really... you can figure it out with EXPLAIN one by one, or run a query then check the counter, or hope that they get pulled into the slow query log (usually 100K of rows examined). Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378091 Share on other sites More sharing options...
shamoon Posted October 25, 2007 Author Share Posted October 25, 2007 I've logged all the queries and run explains on everything. What sort of things should I be looking for? Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378093 Share on other sites More sharing options...
fenway Posted October 25, 2007 Share Posted October 25, 2007 In EXPLAIN, look for "ALL" or "INDEX"... rewriting everything as proper JOINs often helps too. Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378095 Share on other sites More sharing options...
shamoon Posted October 25, 2007 Author Share Posted October 25, 2007 In EXPLAIN, look for "ALL" or "INDEX"... rewriting everything as proper JOINs often helps too. In the "ref" column? Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378106 Share on other sites More sharing options...
fenway Posted October 25, 2007 Share Posted October 25, 2007 The "type" column, no? Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378114 Share on other sites More sharing options...
shamoon Posted October 25, 2007 Author Share Posted October 25, 2007 Where do I look for ALL or INDEX? Which column in the explain? Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378153 Share on other sites More sharing options...
fenway Posted October 26, 2007 Share Posted October 26, 2007 Didn't I just answer that? The "type" column.... see here. Quote Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378598 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.