RE: MySQL/Cron problem

[Dathan Vance Pattishall]

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 that the PHP
version in use has a memory leak. 1st you need to make sure that the
memory is not being put into a cache pool.



- 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: Thursday, September 18, 2003 10:24 AM
-->To: [EMAIL PROTECTED]
-->Subject: RE: MySQL/Cron problem
-->
-->Somebody suggested that I create the cron job as a php scripts, so I
-->did:
-->
-->include("dbinfo.inc.php");
-->
-->$connect = MYSQL_CONNECT($hostname, $username, $password) OR
DIE("Unable
-->to connect to the database");
-->@mysql_select_db( "$dbName") or die( "Unable to select database");
-->$insert = "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;";
-->$query = mysql_query($insert);
-->$delete = "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 Linden [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, September 17, 2003 2:32 PM
-->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]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]