[KLUG Members] triggering a program

[Jamie McCarthy]

adam at morrison-ind.com (Adam Tauno Williams) writes:

> I don't know enough about MySQL but can you identify the file
> that contains the table in question?  You can probably watch it
> for modification via fam

Depends on the table type and a few other settings.

SQL polling will take minimal resources.  If the table isn't
changing, a SELECT MAX(id) hits the query cache, so not only does it
not even read the table data or indexes, or engage the optimizer,
mysqld doesn't even need to parse the incoming query!  :)
-- 
  Jamie McCarthy
 http://mccarthy.vg/
  jamie at mccarthy.vg