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?