Is there not a faster and less processor/memory intensive way of doing this as this makes the server with all our live sites so slow to respond it is almost unusable - the perl script hogs 98% of the processor and all the available ram.
The old Nadmin scripts were faster but they also were 1) horrid hack (manipulate the database timestamps directly to "force" or "prevent" replication) 2) very unreliable.
You can use the nice-command to run the script at lower priority (nice -n15 remove_unapproved.pl dump.xml), however this does not prevent it from hogging the ram it needs (which will be in the range of the size of the input file before it's finished), increasing the available swap (or preferably ram) is the only solution to memory running out alltogether.
/Rambo
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
