MySQL slow
Jim Douglas
jdz99 at hotmail.com
Sun Aug 26 23:18:10 UTC 2007
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 at georgeanelson.com>
>Reply-To: For users of Fedora <fedora-list at redhat.com>
>To: <fedora-list at redhat.com>
>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 at georgeanelson.com>
> ' <http://www.georgeanelson.com/>
>
>--
>fedora-list mailing list
>fedora-list at redhat.com
>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
More information about the users
mailing list