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 infodone (12858 unique products, 1 secs).
creating product tablesdone (7 sec).
getting all presold itemsdone (1 sec).
getting order historydone (13 sec).
*mysql 5:*
getting all product infodone (12858 unique products, 0 secs).
creating product tablesdone (273 sec).
getting all presold itemsdone (1 sec).
getting order historydone (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
