Date: Wed, 31 Mar 2004 19:10:36 -0800 (PST) From: Daryl Chance <chancedj@yahoo.com> To: current@freebsd.org Subject: FBSD 5.2.1-p4 and mysqld problems Message-ID: <20040401031036.77156.qmail@web9602.mail.yahoo.com>
next in thread | raw e-mail | index | archive | help
we are having a couple problems with mysql on FreeBSD 5.2.1 the dmesg is located here: http://sql.tribalwar.com/dmesg.today It's just a generic config with IPv6 removed and the ix86 stuff removed (just i686 left). one of the problems we are having is that there is 1 specific table in the db (and it's only 1 database too that this happens) is getting corrupted and forcing us to have to repair it. This one could just be a problem with mysql and it's just accelerated w/ using it on FreeBSD 5.x. We haven't nailed any specific time that this happens nor any specific insert/select/update that could cause it. Is there any way to verify (through FreeBSD userland commands or ports that you may know of) that this isn't a drive problem? Is there something I can run on FBSD that will help me to track this problem down (perhaps some sort of GEOM logging)? the other problem we are having is that mysql will lock up. 1 of the mysqld processes freezes (uses up all the cpu) and it won't allow anymore queries against it until we shutdown. Is there any way for me to debug this and find out where it is hanging? Is there a working alternative to truss? Or should I just compile option PROCFS in and use it next time it locks? I realize that we shouldn't be running this as a production server, but other then these issues with mysql, the server and it's webserver counterpart are rock solid. Should I upgrade to 5-CURRENT and run it for a couple days before trying to assuming these are new issues :)? also, we are running against linuxthreads but also get this problem with the default threading in FBSD (libc_r?) for 5.2.1 Daryl __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040401031036.77156.qmail>