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