List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:May 25 1999 7:50pm
Subject:Re: mysql running very slow
View as plain text  
kenford@stripped wrote:
> 
> 1. I'm trying to build a search engine using mysql, what can I do to
> have mysql be very fast multi cpu, lots of memory, clustering what?
> 
> 2. Is it normal for mysql to take this long to do a search with just
> 900,000 documents, what about when I have say 10-20,000,000 documents it would
> take for ever.
> 
> mysql> select count(dom_country) from url_info_tb;
> +--------------------+
> | count(dom_country) |
> +--------------------+
> |             991851 |
> +--------------------+
> 1 row in set (0.02 sec)
> 
> 2.
> mysql> select dom_country from url_info_tb where dom_country='edu';
> 
> | edu         |
> | edu         |
> | edu         |
> | edu         |
> | edu         |
> +-------------+
> 80 rows in set (34.39 sec)

Is there an index on dom_county? Use EXPLAIN on the last query. It
should point you in the right direction.

  jim...
Thread
mysql running very slowkenford25 May
  • Re: mysql running very slowJim Faucette25 May
Re: mysql running very slowkenford26 May
  • Re: mysql running very slowDaniel Koch26 May