Re: MySQL slow

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux