mysql 5 performance

2009-01-30 Thread lance raymond
Sorry if this seems to be a double post, but not sure if the mysql list send yourself a copy (as I didn't get the 1st one). But a little has changed, not much, but basically I have an old fc5 machine running mysql 4.1 and a newer server running centos5 / mysql 5.0.45. The whole site is almost

Re: mysql 5 performance

2009-01-30 Thread Perrin Harkins
On Fri, Jan 30, 2009 at 9:32 AM, lance raymond lance.raym...@gmail.com 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

Re: mysql 5 performance

2009-01-30 Thread Walter Heck
creating product tablesdone (273 sec). Can you tell us what queries this code actually executes? This doesn't tell us too much ;) Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Fri, Jan 30, 2009 at 3:32 PM, lance raymond

Re: mysql 5 performance

2009-01-30 Thread Baron Schwartz
Hi Lance, Please post specific queries and EXPLAIN output with the \G terminator. It's likely your queries that are the problem, and looking at 'ps' doesn't help you much. On Fri, Jan 30, 2009 at 9:32 AM, lance raymond lance.raym...@gmail.com wrote: Sorry if this seems to be a double post, but