> creating product tables....done (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 <lance.raym...@gmail.com> wrote: > 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 > unusable now (the older server is having hard drive issues and being > replaced), and I think it's just a mysql 5 startup or config change but I am > not sure. Our test page shows the queries with the query times, and here is > just one admin page; > *mysql4:* > getting all product info....done (12858 unique products, 1 secs). > creating product tables....done (7 sec). > getting all presold items....done (1 sec). > getting order history....done (13 sec). > > *mysql 5:* > getting all product info....done (12858 unique products, 0 secs). > creating product tables....done (273 sec). > getting all presold items....done (1 sec). > getting order history....done (15 sec). > > I don't know but guessing now, mysql 5 shows the following 2 items running > on a ps list; > > /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql > --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log > --pid-file=/var/run/mysqld/mysqld.pid > > /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql > --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking > --socket=/var/lib/mysql/mysql.sock > > Questions; > 1.Do I need external-locking skipped? > 2.Are there tools like mtop for mysql 5 to monitor what's going on? The box > (even on the 200+ second page loads) is sitting at 95% idle with no real > load. > 3. MySql 4 process list shows an actual tree; > 19188 ? S 0:00 /bin/sh /usr/bin/mysqld_safe > --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/classic.pid > 19219 ? S 0:03 \_ [mysqld] > 19220 ? S 0:05 \_ [mysqld] > 19221 ? S 0:00 \_ [mysqld] > 19222 ? S 0:00 \_ [mysqld] > 19223 ? S 0:00 \_ [mysqld] > 19224 ? S 0:00 \_ [mysqld] > 19225 ? S 0:00 \_ [mysqld] > 19226 ? S 0:06 \_ [mysqld] > 19227 ? S 0:00 \_ [mysqld] > 19228 ? S 0:02 \_ [mysqld] > > I am not sure, but does that mean it's multi-threading allowing multiple > things to be done at once? If so, is that possible on mysql5. > > I may be way off on one or all, but at least some sort of reply is > appreciated. It's been 3 day's, I see some of the questions being thrown > out and answered so I know it's an active list, so am I assuming no-one has > upgraded from 4 to 5 and seen this? > > Anything to help me start fixing this is apprecited. > Lr > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
