You didn't get a response on this one because you didn't really ask any questions :-)
Baron On Thu, Jan 29, 2009 at 4:38 PM, lance raymond <lance.raym...@gmail.com> wrote: > Man, the forums are good, but lists are just so much easier! Anyway, I left > post unanswered now and I need to get this problem solved, so I am hoping > this list is more direct. > > Basically a fc5/mysql4 server is having hard drive errors. We had a > slightly newer/faster server, so I staged it with centOS5, mysql5. The > server is expanentially slower, and I am trying to see if there is anything > db wise I can look / tweak. Basically the mysql 4 server looks to have > numerous threads running see the ps snapshot; > > 25243 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql > --pid-file=/var/lib/mysql/classic.pid > 25274 ? S 0:25 \_ [mysqld] > 25275 ? S 0:37 \_ [mysqld] > 25276 ? S 0:00 \_ [mysqld] > 25277 ? S 0:00 \_ [mysqld] > 25278 ? S 0:00 \_ [mysqld] > 25279 ? S 0:00 \_ [mysqld] > 25280 ? S 0:00 \_ [mysqld] > 25281 ? S 0:03 \_ [mysqld] > 25282 ? S 0:00 \_ [mysqld] > 25283 ? S 0:15 \_ [mysqld] > > The mysql 5 shows the following running; > root 10245 0.0 0.0 4472 1092 pts/0 S 23:13 0:00 /bin/sh /usr/bin/mysqld_safe > --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid > --log-error=/var/log/mysqld.log > mysql 10281 5.8 1.1 141544 24028 pts/0 Sl 23:13 0:19 /usr/libexec/mysqld > --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql > --user=mysql --pid-file=/var/run/mysqld/mysqld.pid > *--skip-locking*--socket=/var/lib/mysql/mysql.sock > > I first tried to start it by hand with the slow-log options, but never saw a > file. Then tried in the my.cnf file and still nothing and also noticed the > skip-locking option running where I don't see it in the startup. > > So all the above comes down to this question(s). Should mysql5 with a > generic rpm install run this slow compared to mysql 4. A query that takes > 24 seconds is taking more than 5 minutes and I am wondering if it's a thread > issue, etc. as this is a live webserver with hundreds on in/out connections. > > Thanks on getting me started on this one > -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
