At 11:18 PM +0000 8/26/07, Jim Douglas wrote: >>From: Tony Nelson <tonynelson@xxxxxxxxxxxxxxxxx> >>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)? -- ____________________________________________________________________ TonyN.:' <mailto:tonynelson@xxxxxxxxxxxxxxxxx> ' <http://www.georgeanelson.com/>
