in reply to How to check for new records in mysql database every minute

Maybe you want to read the SQL log for that?

Edit:
And I dreamed it was that easy. You would have to parse the binary Update log instead, so I hope there is an easier way to solve your problem.

Cheers, Sören

  • Comment on Re: How to check for new records in mysql database every minute

Replies are listed 'Best First'.
Re^2: How to check for new records in mysql database every minute
by tachyon (Chancellor) on Oct 05, 2004 at 21:55 UTC
    The mysqlbinlog utility will parse the binlog for you and takes all sorts of arguments like a start and stop time for instance. You don't need to but wrapping it with XS would be easy.

    cheers

    tachyon