Event-based deletion of old database entries: Difference between revisions

From Aquarium-Control
Jump to navigation Jump to search
(Created page with "Add the line <code>event_scheduler=ON</code> to MariaDb configuration file (usually <code>/etc/mysql/my.cnf</code>). <pre> # The MariaDB configuration file # # The MariaDB/MySQL tools read configuration files in the following order: # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults, # 2. "/etc/mysql/conf.d/*.cnf" to set global options. # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options. # 4. "~/.my.cnf" to set user-specific options. # # If...")
 
No edit summary
Line 1: Line 1:
Add the line <code>event_scheduler=ON</code> to MariaDb configuration file (usually <code>/etc/mysql/my.cnf</code>).
Active the event scheduler by adding the two last lines of below example to MariaDb configuration file (usually <code>/etc/mysql/my.cnf</code>).


<pre>
<pre>
Line 25: Line 25:
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
!includedir /etc/mysql/mariadb.conf.d/
[mysqld]
event_scheduler=ON
event_scheduler=ON
</pre>
</pre>

Revision as of 06:18, 2 August 2025

Active the event scheduler by adding the two last lines of below example to MariaDb configuration file (usually /etc/mysql/my.cnf).

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

[mysqld]
event_scheduler=ON