RE: MySQL/Cron problem

2003-09-18 Thread Jason Linden
rsday, September 18, 2003 1:42 PM To: 'Jason Linden'; [EMAIL PROTECTED] Subject: RE: MySQL/Cron problem What do you mean it doesn't release itself? Can you provide some free examples of before and after then 5 min after that? The indication from the content of the below message is tha

RE: MySQL/Cron problem

2003-09-18 Thread Jason Linden
uot;DELETE from sysklog;"; $query = mysql_query($delete); mysql_close($connect); I am still having the same issue, when the above script runs every minute memory usage increases by 200-500k and doesn't release itself. Any ideas/suggestions? Thanks! -Original Message- From: Jason Lind

RE: MySQL/Cron problem

2003-09-17 Thread Jason Linden
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 n

MySQL/Cron problem

2003-09-17 Thread Jason Linden
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 (machi