Differences

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

--- servers:bsd:mariadb [2025/10/30 16:58] – Sean Rhone
+++ servers:bsd:mariadb [2026/01/09 17:24] (current) – [Script] Sean Rhone
@@ Line 1: / Line 1: @@
 ====== Information ======
-  * MariaDB
+  * MariaDB ((https://mariadb.org/))
+  * Server
+  * [[information:realm_of_espionage|Realm of Espionage]]
 ===== Prerequisites =====
-  * [[bsd:server:freebsd_14.3|FreeBSD 14.3]]
+  * [[bsd:server:freebsd_16.0|FreeBSD 16.0]]
 ====== Dependencies ======
@@ Line 33: / Line 35: @@
 expire_logs_days = '7'
 max_binlog_size = '100M'
-#skip-networking = 'On'
+skip-networking = 'Off'
 table_definition_cache = '1400'
@@ Line 60: / Line 62: @@
   mariadb-secure-installation
-====== Optimize ======
+====== Database Repair and Optimization ======
-****
+===== One-shot =====
-  mariadb-check -u 'root' -p -o -A -f -e --auto-repair
+  su -
-====== Other ======
+  mariadb-check -o -A -f -e --auto-repair
+===== cron =====
+==== Script ====
+  mkdir -p ~/'.local/scripts/mariadb' && ee ~/'.local/scripts/mariadb/optimize.sh' && chmod +x ~/'.local/scripts/mariadb/optimize.sh'
+<code>
+#!/bin/sh
+'/usr/local/bin/mariadb-check' -o -A -f -e --auto-repair > '/dev/null'
+'/bin/sync'
+# End</code>
+  su 'root' -c ~/'.local/scripts/mariadb/optimize.sh'
+==== cron ====
+  * Weekly (Sunday) ''07:10:00 AM''
+  su -
+  ee '/etc/cron.d/mariadb-optimize'
+<code>
+#
+SHELL=/bin/sh
+7 * * sun root '/home/espionage724/.local/scripts/mariadb/optimize.sh'
+# End</code>
+====== Notable Commands ======
 ===== Binaries =====
@@ Line 74: / Line 111: @@
   pkg info -l 'mariadb118-client' | grep 'bin'
-===== Settings Query =====
+===== Settings =====
-****
+  su -
-  mariadb-admin -u 'root' -p variables | egrep 'utf8|networking|socket'
+  mariadb-admin variables | egrep 'utf8|networking|socket'
-===== Socket =====
+===== Show Users on Server =====
+  su -
-  mariadb-admin variables -u 'root' -p | grep 'socket'
+  mariadb
-  /var/run/mysql/mysql.sock
+  select User,Host from mysql.user;