maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Savita!

On Mar 09, Savita Agrawal wrote:
> 
> As far as I know user defined events are supposed to save applications
> resources used in polling. But I think the application developer could
> have created a trigger and udf and use lib_mysqludf_sys to invoke
> external application. But there are security issues in this method.
> Is it the primary/only reason for this project?

It has little to do with external applications. The idea is to be able
to wait for something to happen. It might be used with external
applications, I agree:

  WAIT EVENT
    WHEN mysqldump_finished BEGIN
      ...
    END

and then run mysqldump (in another window) that will
POST mysqldump_finished.

But waiting could also be useful without external applications.

Regards,
Sergei