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 wrote:
> Sorry if this seems to be a double post, but not sure if the mysql
> 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
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
qu
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
unu
