mysql q

[Erez D]

hello

i have a web page that refreshes all the time to display things from a
mysql database which is updated from time to time.
however. this meens a lot of un-needed acesses to the database. and this
refresshing page may be openede by many browsers. causing a huge load on
the database.

i know mysql supports triggers, but it seems this is only internal (i.e.
trigger may do a query, usually an "update" query, but this is not what i
need).

I am looking for a way to leave the connection open with mysql, not sending
any queries, just waiting for mysql to notify me when a somthing changes.

does mysql support that ?
examples of doing that will be nice


thanks,
erez.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20131117/ffc2d8dd/attachment.html>