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:  [EMAIL PROTECTED]
>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 |
| [EMAIL PROTECTED]                               Computer Consultant |
| http://aesric.ucdavis.edu/                  http://pgfsun.ucdavis.edu/ |
+-------------------------------------- FBI Special Agent Dale Cooper ---+

---------------------------------------------------------------------
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

Reply via email to