List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:January 22 2001 4:36pm
Subject:Re: Veeery slow.
View as plain text  
At 2:15 PM +0100 1/22/01, Torkil Grindstein wrote:
>Hi.
>
>I'm running a mysql database, to which queries seem to take way
>too much time. The database contains just two tables, each with
>approx 10.000 rows. Simple select() calls to these can take more
>than a minute. Can this be right?


Can you post some examples of your queries, along with EXPLAIN SELECT 
output? It's hard to give much more information based upon this post, 
but one possibility is that you have no keys - or no useable keys - 
on those tables. See

	http://www.mysql.com/doc/E/X/EXPLAIN.html

Also, you might find some more info in the list archives; try a 
search for 'slow queries' or 'slow query' at

	http://lists.mysql.com/php/search.php
or
	http://marc.theaimsgroup.com/?l=mysql&r=1&w=2


>
>My platform is a RedHat 6.1, running MySQL-3.22.32-1.
>
>Should I upgrade to RH 7.0 and MySQL-3.23-32?
>--
>Torkil Grindstein                 Mail:  Torkil.Grindstein@stripped
>System Architect                  Web:   http://www.fast.no
>Fast Search & Transfer ASA        Phone: +47 21 60 11 90
>Grønnegata 80, Pb 571             Fax:   +47 77 69 66 89
>NO-9261 Tromsø, NORWAY            Mob:   +47 98 06 61 38
>
>Try FAST Search: http://www.alltheweb.com
>


	- steve edberg

-- 
+--- "They've got a cherry pie there, that'll kill ya" ------------------+
| Steve Edberg                           University of California, Davis |
| sbedberg@stripped                               Computer Consultant |
| http://aesric.ucdavis.edu/                  http://pgfsun.ucdavis.edu/ |
+-------------------------------------- FBI Special Agent Dale Cooper ---+
Thread
Veeery slow.Torkil Grindstein22 Jan
  • Re: Veeery slow.Steve Edberg22 Jan