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
Kyle Mott wrote:> > 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 getToday (June 9th) I update my world and kernel, and I encountered a big problem; my web-browsers (mozilla and opera) cannot resolve hostnames anymore. I have then downgraded to Stable world/kernel of June 1st, which solved the problem. Next I updated to June 5th, which was also OK. At present I'm trying June 7th, trying to zoom in on what commit(s) have caused this problem. I don't know anything of Mysql, but I just wondered if there's a connection. Regards, Rob.
On Tue, 8 Jun 2004, Kyle Mott wrote:> > 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.MySQL forks a child (or starts a new linuxthread depending on how its configured) for each connection. The Nagios check would cause the new process to be spawned. They should just exit, though. Check 'mysqladmin processlist' or 'show processlist;' from the monitor to see who's connected and what they're doing. Its also possible that mysql will keep threads around once they've been used to avoid exiting & respawning threads constantly. I haven't run MySQL 4.x and looked at it that closely. -- Doug White | FreeBSD: The Power to Serve dwhite@gumbysoft.com | www.FreeBSD.org