You could put a trigger on the table.
See MySql trigger docs here...
http://dev.mysql.com/doc/maxdb/en/a7/41ee0b605911d3a98800a0c9449261/content.htm
You could have this trigger insert into another table for each row that is inserted, updated or deleted.
You would then write a perl program to select from this new 'transaction' table.
This will keep you from doing full table scans off the actual table trying to determine the new records and gives you a way of knowing the records that were deleted.

Update:
Ok, dragonchild points out that triggers are not prime time yet. Can you change the API that does the Insert/Update/Deletes to the table? If you can then you can simulate a trigger by populating a 'transaction' table there. Deletes are the tricky part of your requirements and will require some kind of transaction queueing to manage.

In reply to Re: How to check for new records in mysql database every minute by mifflin
in thread How to check for new records in mysql database every minute by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.