MySQL slow
Tony Nelson
tonynelson at georgeanelson.com
Mon Aug 27 03:38:34 UTC 2007
At 11:18 PM +0000 8/26/07, Jim Douglas wrote:
>>From: Tony Nelson <tonynelson at 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)?
--
____________________________________________________________________
TonyN.:' <mailto:tonynelson at georgeanelson.com>
' <http://www.georgeanelson.com/>
More information about the users
mailing list