LinuxThreads look like processes in a process list. There is only one mysqld instance and 11 connections to it.
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Jason Linden [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, September 17, 2003 11:32 AM -->To: [EMAIL PROTECTED]; [EMAIL PROTECTED] -->Subject: RE: MySQL/Cron problem --> -->Tried it... didn't do anything. Also, there are 11 different instances -->of mysql running. Any ideas why? Or is that just how it works? --> -->-----Original Message----- -->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, September 17, 2003 9:37 AM -->To: [EMAIL PROTECTED]; [EMAIL PROTECTED] -->Subject: Re: MySQL/Cron problem --> -->Hmmm, have you tried putting is a folling mysqladmin flush-threads -->command? --> -->-----Original Message----- -->From: Jason Linden [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, September 17, 2003 8:57 AM -->To: [EMAIL PROTECTED] -->Subject: MySQL/Cron problem --> -->I am fairly new to both linux and mysql. I have a cron job that runs -->every minute to move data from one mysql table to another (both tables -->are in the same database), see below: --> -->Cron job is: --> -->mysql -u *** --password=*** syslog < /var/scripts/updsysklog2 --> -->Script is: --> -->INSERT INTO sysklog2 (machine,facility,priority,logdate,logtime,message) -->SELECT machine, facility, priority, cast(left(date1,8) as date) as -->logdate, cast(right(date1,6) as time) as logtime, message FROM sysklog; -->DELETE FROM sysklog; --> -->The problem I am having is every time this runs it adds ~250k to memory -->and doesn't release it then server locks up every 5 or 6 days. --> -->Any ideas on how to fix this? --> -->Thanks! --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
