6 messages in com.mysql.lists.mysqlRe: 45 seconds
FromSent OnAttachments
Elsad YUSIFLI10 Jun 2002 07:10 
George Pitcher10 Jun 2002 07:31 
Harrison C. Fisk10 Jun 2002 08:58 
Chris Knipe10 Jun 2002 10:23 
Nilesh Shah10 Jun 2002 10:48 
Keith C. Ivey10 Jun 2002 10:56 
Subject:Re: 45 seconds
From:George Pitcher (phpd@yahoo.co.uk)
Date:06/10/2002 07:31:08 AM
List:com.mysql.lists.mysql

Check that your fields are indexed.

This usually fixes it.

George

----- Original Message ----- From: "Elsad YUSIFLI" <els@devel.gazi.edu.tr> To: <mys@lists.mysql.com> Sent: Monday, June 10, 2002 3:10 PM Subject: 45 seconds

i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu

SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20

--------------------------------------------------------------------- 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-phpdevuk=yaho@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php