I installed MySQL on Fedora 6 and simple queries are very slow.

I have ten databases with very few hundred records and there are only a few
hundred records in the table I am querying. I only have this issue on
Fedora ONLY. The same query on on my Windows machine is as expected.

What can I do to speed things up on Fedora?

Jim

__________________________________________________ _______________
See what you’re getting into…before you go there
http://newlivehotmail.com/?ocid=TXT_...l_preview_0507

Hi Jim -

I'm using MySQL on Fedora 6 as well, with no performance problems. Did not
need to do anything to speed it up on Fedora.

It's difficult to answer the question why one is faster than the other, as
there are any number of potential differences. Some more specifics about
your setup (hardware, software) and the queries you're running would be
ful. The output of EXPLAIN from both machines may be very telling.

In general, some things to consider are:
- do you have sufficient RAM in the Fedora machine for what you're running?
If you're paging memory that can slow things down a lot
- are you running the same version of MySQL on the two machines? Older
versions can perform particularly poorly with subqueries, for example
- do you have the MySQL query cache enabled on Windows and not on Fedora, or
cache settings that are very different?

Dan


On 8/26/07, Jim Douglas <jdz99@hotmail.com> wrote:
>
> I installed MySQL on Fedora 6 and simple queries are very slow.
>
> I have ten databases with very few hundred records and there are only a
> few
> hundred records in the table I am querying. I only have this issue on
> Fedora ONLY. The same query on on my Windows machine is as expected.
>
> What can I do to speed things up on Fedora?
>
> Jim
>
> __________________________________________________ _______________
> See what you're getting into…before you go there
> http://newlivehotmail.com/?ocid=TXT_...l_preview_0507
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com
>
>