Defining trigger conditions for events
Each event definition has a system event associated with it. It also has one or more trigger conditions. The event handler
is triggered when the trigger conditions for the system event are satisfied.
The trigger conditions are included in the WHERE clause of the CREATE EVENT statement, and can be combined using the AND keyword.
Each trigger condition is of the following form:
event_condition( condition-name ) comparison-operator value
The condition-name argument is one of a set of preset strings, which are appropriate for different event types. For example, you can use DBSize (the database file size in megabytes) to build a trigger condition suitable for the GrowDB system event. The database server does not check that the condition-name matches the event type: it is your responsibility
to ensure that the condition is meaningful in the context of the event type.
- Limit the transaction log size to 10 MB:
- Notify an administrator when free disk space on the device containing the database file falls below 10%, but do not execute
the handler more than once every five minutes (300 seconds):
- Notify an administrator of a possible attempt to break into the database:
- Run a process when the server has been idle for ten minutes. Do not execute more frequently than once per hour: