Hi Jim - I'm using MySQL on Fedora 6 as well, with no performance problems. Did not need to do anything to speed it up on Fedora.
It's difficult to answer the question why one is faster than the other, as there are any number of potential differences. Some more specifics about your setup (hardware, software) and the queries you're running would be helpful. The output of EXPLAIN from both machines may be very telling. In general, some things to consider are: - do you have sufficient RAM in the Fedora machine for what you're running? If you're paging memory that can slow things down a lot - are you running the same version of MySQL on the two machines? Older versions can perform particularly poorly with subqueries, for example - do you have the MySQL query cache enabled on Windows and not on Fedora, or cache settings that are very different? Dan On 8/26/07, Jim Douglas <[EMAIL PROTECTED]> 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? > > Jim > > _________________________________________________________________ > See what you're getting into…before you go there > http://newlivehotmail.com/?ocid=TXT_TAGHM_migration_HM_viral_preview_0507 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
