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