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?
Jim
_________________________________________________________________ See what youre getting into before you go there http://newlivehotmail.com/?ocid=TXT_TAGHM_migration_HM_viral_preview_0507
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.
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@georgeanelson.com Reply-To: For users of Fedora fedora-list@redhat.com To: fedora-list@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@georgeanelson.com ' http://www.georgeanelson.com/
-- fedora-list mailing list fedora-list@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
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)?
Somebody in the thread at some point said:
I talking about a instantenous query on the Windows machine that takes 10 seconds or more on the Linux machine.
Is it an external network-based connection to the MySQL server or all on localhost? If it is an external network-based connection, the first place to look would be DNS problems. How do you specify the machine name the server is on?
Is DNS working on both boxes?
tcpdump the connection while you do one of these slow lookups and see if that gives a clue.
-Andy