One thing I might suggest is to queue up your inserts, then use the extended
insert syntax to populate several records at once in a single INSERT instead
of 12 separate ones. I believe you can alter the /etc/my.cnf file to play
more 'nice' as far as priorities and memory, but I've never touched it
  

> -----Original Message-----
> From: Ryan Marks [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 11, 2003 6:45 PM
> To: PHP-DB
> Subject: [PHP-DB] Cronjob
> 
> Hello all,
> 
> I have a cronjob that runs a PHP script against MySQL.  The 
> script takes 5
> minutes to process 4000 records (approximately 12 records per 
> second).  Here
> are the top two entries from top:
>   PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME 
> CPU COMMAND
>  8671 mysql     25   0 20172  19M  2000 R    97.8  3.9   2:02 
>   0 mysqld
>  8670 appmgr    15   0  2088 2088  1424 S     2.2  0.4   0:03   0 php
> 
> Is there a way that I can slow down the script so mysqld does 
> not bog the
> machine down.
> 
> Here is a snippet of code.  The function is called by the cronjob.
> <snip>
> function rank_mailbox_current($company_ID){
>       $query = "select app_ID from mailbox where company_ID = 
> \"$company_ID\"
>               and deleted_date = 0 order by mailbox.ID desc";
>       $result=query_database($query);
> 
>       while ($row = mysql_fetch_assoc($result)){
>               $app_ID = $row["app_ID"];
>               $rank_of_app=rank_app($app_ID,$company_ID);
>       }
> }
> </snip>
> 
> Server: P-IV 2.4GHz, 512 DDRAM, RedHat 9
> PHP Version 4.3.1
> MySQL 4.0.3
> 
> Thanks,
> Ryan
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to