I've been monitoring slow-queries.log to try and find querys that might be causing problems. I see the following logged:
# Time: 020903 16:59:14 # User@Host: cfweb[cfweb] @ storm.centurytel.net [10.10.1.17] # Query_time: 47 Lock_time: 0 Rows_sent: 5 Rows_examined: 145240 SELECT clari_category.image_exists, clari_article.id, clari_article.image_url_standard FROM clari_category LEFT JOIN clari_article ON clari_category.id = clari_article.id WHERE clari_category.datestamp > '2002-09-01' AND clari_category.image_exists = '0' AND clari_article.image_url_standard != ''; But when I do an explain on the same query I get: +----------------+--------+---------------------------------------------------------------+-------------+---------+-------------------+------+------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +----------------+--------+---------------------------------------------------------------+-------------+---------+-------------------+------+------------+ | clari_category | ref | idx_imagekey,idx_imagestoryvalidation,idx_datestamp,idx_photo | idx_photo | 1 | const | 1448 | where used | | clari_article | eq_ref | idx_primary,idx_datearticle | idx_primary | 100 | clari_category.id | 1 | where used | +----------------+--------+---------------------------------------------------------------+-------------+---------+-------------------+------+------------+ 2 rows in set (0.00 sec) I don't understand why the query is examining 145240 rows when explain says it should be limited to 1448? Am I missing something? __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php