dump/restore or sometimes I just ran the .sql file through the Query
Browser.
If it runs well on the Wwindos macihne w/o an index it should have similar
performance on the Linux machine.
I talking about a instantenous query on the Windows machine that takes 10
seconds or more on the Linux machine.
Jim
From: Tony Nelson <tonynelson@xxxxxxxxxxxxxxxxx>
Reply-To: For users of Fedora <fedora-list@xxxxxxxxxx>
To: <fedora-list@xxxxxxxxxx>
Subject: Re: MySQL slow
Date: Sun, 26 Aug 2007 16:17:16 -0400
At 7:41 PM +0000 8/26/07, Jim Douglas 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?
Indexes?
What kind of tables (MyISAM, InnoDB)?
How did you get the databases onto the Fedora machine? Onto the MSWindows
machine? Via a dump and restore, or directly moving the files?
What MySQL version is the Fedora machine using? The MSWindows machine?
--
____________________________________________________________________
TonyN.:' <mailto:tonynelson@xxxxxxxxxxxxxxxxx>
' <http://www.georgeanelson.com/>
--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
_________________________________________________________________
Tease your brain--play Clink! Win cool prizes!
http://club.live.com/clink.aspx?icid=clink_hotmailtextlink2