Re: log-queries-not-using-indexes and "Using index" in the Extra col of Explain

2008-07-29 Thread MySQLForum MySQLForum
cardinality). > > -Original Message- > From: MySQLForum MySQLForum [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 29, 2008 6:35 AM > To: mysql@lists.mysql.com > Subject: log-queries-not-using-indexes and "Using index" in the Extra > col of Explain > > Hi Al

RE: log-queries-not-using-indexes and "Using index" in the Extra col of Explain

2008-07-29 Thread Mary Bahrami
From: MySQLForum MySQLForum [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 6:35 AM To: mysql@lists.mysql.com Subject: log-queries-not-using-indexes and "Using index" in the Extra col of Explain Hi All, I have been using mysql 5.1.26-rc on Linux and configured to log queries that d

log-queries-not-using-indexes and "Using index" in the Extra col of Explain

2008-07-29 Thread MySQLForum MySQLForum
Hi All, I have been using mysql 5.1.26-rc on Linux and configured to log queries that do not use index through log-queries-not-using-indexes I would like to ask two questions, please: 1) I have noticed that in some cases some queries get logged because a scan of the index on a field is executed.