[#MDEV-30645] CREATE TRIGGER FOR { STARTUP

[MDEV-30645] CREATE TRIGGER FOR { STARTUP \| SHUTDOWN } Created: 2023-02-13 Updated: 2023-04-19
Status:	Open
Project:	MariaDB Server
Component/s:	Events, Triggers
Fix Version/s:	None

Type:

Task

Priority:

Major

Reporter:

Mitchell Lee

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

beginner-friendly

Issue Links:

Relates
relates to	MDEV-30640	Feature request - Extend maximum obje...	Open
relates to	MDEV-30643	Feature request - Allow concat functi...	Open
relates to	MDEV-30644	Feature request - A function for curr...	Open

Description

Event Schduler Trigger when right after STARTUP / right before Shutdown.
> not only time repeatation. but one time call for STARTUP and Shutdown
> Should prepared alternative method to turn of/off switch by configuration for emergency.

To know DB's startup and shutdown
prepare system batch data(like mart).

Comments

Comment by Sergei Golubchik [ 2023-02-27 ]

or may be

CREATE TRIGGER ... AFTER STARTUP ...

CREATE TRIGGER ... BEFORE SHUTDOWN ...

Comment by Mitchell Lee [ 2023-02-28 ]

@Sergei Golubchik, exactly what I want.

Generated at Thu Feb 08 10:17:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.