Process accounting and logrotate

[mattward2k]

I've been using psacct to keep track of resource usage of mutiple MySQL sandboxes running under different linux users, which it keeps track of quite effectively. However I'm having issues when it comes to logrotate.

Presumably when you start a new process for a user that doesn't exist in the log, with process accounting turned on, it notices this and makes an entry in /var/account/psacct (or whever you've got your process accounting log) for that user. However, when this log gets rotated (it gets pretty big pretty quickly), there are no longer entries for the MySQL sandbox users (because those users don't have any new processes with which to create a new entry in the psacct log, but the MySQL process is there and still running, but isn't having its resource usage appended to psacct).

Does anyone out there who knows about process accounting know anything about this, or an effective way to be able to rotate the log (start the recording of users anew, with fresh, reset resource figures) without having to restart existing processes, so they're just appended as before?

[mattward2k]

Or, more simply:

How can I get a fresh start of psacct to track existing processes that are already running?