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? 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). 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? 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. 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? 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? 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? 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. Link to comment https://forums.phpfreaks.com/topic/74784-mysql-optimization-and-tracking/#findComment-378598 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.