RoE | Wiki

User Tools

Site Tools

Trace:
servers:mariadb

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
servers:mariadb [2020/07/28 21:20] – Add "table_definition_cache" for friendica Sean Rhoneservers:mariadb [2021/06/18 17:17] – Sean Rhone
Line 6: Line 6:
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[distros:ubuntu_server|Ubuntu Server]]+  * [[distros:opensuse_tumbleweed_server|openSUSE Tumbleweed]]
  
 ====== Settings ====== ====== Settings ======
Line 12: Line 12:
   * Settings being done before installation is intentional   * Settings being done before installation is intentional
  
-  sudo -e '/etc/mysql/mariadb.conf.d/custom.cnf'+  sudo mkdir -p '/etc/my.cnf.d' && sudo -e '/etc/my.cnf.d/custom.cnf'
  
 <code> <code>
Line 41: Line 41:
 **** ****
  
-  sudo apt install 'mariadb-server'+  sudo zypper install 'mariadb'
  
 ====== Initial Setup ====== ====== Initial Setup ======
Line 80: Line 80:
 Type=oneshot Type=oneshot
 ExecStart='/usr/bin/mysqlcheck' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force ExecStart='/usr/bin/mysqlcheck' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force
-ExecStartPost='/bin/sync'</code>+ExecStartPost='/usr/bin/sync'</code>
  
 ===== Timer ===== ===== Timer =====
Line 110: Line 110:
 **** ****
  
-  /var/run/mysqld/mysqld.sock+  /var/lib/mysql/mysql.sock 
/var/www/wiki/data/pages/servers/mariadb.txt · Last modified: 2024/03/06 21:01 by Sean Rhone