At 11:18 PM +0000 8/26/07, Jim Douglas wrote:
From: Tony Nelson tonynelson@georgeanelson.com 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?
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.
Well, then you're done, aren't you?
I talking about a instantenous query on the Windows machine that takes 10 seconds or more on the Linux machine.
How do you do the queries? Directly in mysql or via some other interface such as PHP or a web browser?
What MySQL version is the Fedora machine using? The MSWindows machine?
What kind of tables (MyISAM, InnoDB)?