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
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
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
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