Re: Queries slow down daily, optimizing helps -> why?
Posted by:
Rick James
Date: February 27, 2009 07:56PM
More details may be in the slowlog.
Your earlier attempts probably said 24K "Rows examined". This was a full scan of one table, plus probing the other table for every row in the first one.
With the new index, "Rows examined" is probably about 13K -- full scan of one table, filtering out most of the rows, then probing the other table only for the remaining rows.
I would not make a general rule on which table should be "on top" in Explain. There are a zillion things that Explain might say; I enjoy explaining one EXPLAIN at a time. You may find a dozen such postings in this forum, plus Newbie and Optimizer forums.
Subject
Views
Written By
Posted
4251
February 18, 2009 04:54AM
2223
February 18, 2009 09:04AM
2324
February 18, 2009 11:57AM
2263
February 19, 2009 01:00AM
2250
February 19, 2009 01:52AM
2277
February 19, 2009 03:32AM
1713
February 19, 2009 05:08AM
2152
February 19, 2009 12:24PM
2233
February 19, 2009 10:53PM
2339
February 20, 2009 08:34AM
2087
March 18, 2009 03:58AM
2260
February 21, 2009 06:15AM
2181
February 24, 2009 10:02AM
2404
February 26, 2009 02:30AM
2043
February 26, 2009 09:56AM
2221
February 26, 2009 08:14PM
2194
February 27, 2009 01:38AM
Re: Queries slow down daily, optimizing helps -> why?
2132
February 27, 2009 07:56PM
2116
February 28, 2009 06:20AM
2355
February 28, 2009 03:43PM
2249
February 27, 2009 04:21AM