From: Perrin Harkins Date: January 30 2009 4:16pm Subject: Re: mysql 5 performance List-Archive: http://lists.mysql.com/mysql/216089 Message-Id: <66887a3d0901300816n1626e1f5vd702cce9ac10bd1e@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Fri, Jan 30, 2009 at 9:32 AM, lance raymond wrote: > basically I have an old fc5 machine running mysql 4.1 and a > newer server running centos5 / mysql 5.0.45. So, different hardware, different OS, different database server... could be anything. I suggest you run EXPLAIN plans for the slow queries on both servers and compare them. The most likely reasons for a difference that large are missing indexes or vastly different filesystem performance. - Perrin