Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 8 Jun 2004 23:30:43 -0700
From:      "Kyle Mott" <kyle@xraided.net>
To:        <freebsd-stable@freebsd.org>
Subject:   Mysql Problems
Message-ID:  <000301c44deb$4a78f1b0$1414a8c0@kyle>

next in thread | raw e-mail | index | archive | help
 
I've now done buildworld twice, to no avail; for some reason, every 1-3
minutes a new mysql process is started, for which looks like no apparent
reason. Mysql on this machine is used very rarely, though it does get
checked by Nagios regularly. I've had a tough time finding any logs for
mysql, which ended up being in /var/db/mysql but they didn't tell me
anything of relevance (that I can see). I built mysql with linuxthreads,
and I'm using my-small.cnf, not sure if they could be contributing to
the odd behavior. I've also tried rebuilding the port
(/usr/ports/databases/mysql40-server/) several times, which didn't seem
to make a difference.
 
Right now, after being up for 15 minutes, there's 55 mysql processes
(when there's normally < 15). When I run 'top', it says the state for
most of the mysql processes is 'pause', and they are taking very little
resources (thank god). The only other thing I have done is move /var/db
to /usr/db, and then 'ln -s /usr/db /var/db', but everything else seems
to be fine (locate, pgsql, nut, etc.). I thought permissions might have
been wrong, because /var/db/mysql was 0700, so I made it 0755, which
didn't change anything.
 
Any suggestions? I have 2 other systems that I need to update fairly
soon, but I'm afraid to if this is going to happen. :<
 
 
 
-Kyle Mott
 
 
 
 
 



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000301c44deb$4a78f1b0$1414a8c0>