Differences

This shows you the differences between two versions of the page.

--- install_22_4 [2024/08/02 07:37] – system
+++ install_22_4 [2024/09/19 10:20] (current) – [Install MariaDB] system
@@ Line 249: / Line 249: @@
 sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
 </code>
-  * Save the file and restart the MySQL server
+=== Enable the Event Scheduler ===
+  * MariaDB and MySQL has a built in Event Scheduler (like CRON for a database) which is disabled by default.
+  * We make use of this feature to automatically optimize some of the database tables.
+  * We will enable the Event Scheduler in MariaDB by creating a new file /etc/mysql/conf.d/enable_event_scheduler.cnf
+<code bash>
+sudo vi /etc/mysql/conf.d/enable_event_scheduler.cnf
+</code>
+  * Enter these two lines:
+<code bash>
+[mysqld]
+event_scheduler=on
+</code>
+  * Save the file.
+  *  Restart the MySQL server
 <code bash>
 sudo systemctl restart mariadb
+</code>
+  * You can confirm that it is now enabled by checking the following from the SQL terminal:
+<code bash>
+sudo mysql -u root
+MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'event_scheduler';
++-----------------+-------+
+| Variable_name   | Value |
++-----------------+-------+
+| event_scheduler | ON    |
++-----------------+-------+
+row in set (0.001 sec)
 </code>