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 [2019/10/24 13:01] – Sean Rhoneservers:mariadb [2020/07/28 21:20] – Add "table_definition_cache" for friendica Sean Rhone
Line 12: Line 12:
   * Settings being done before installation is intentional   * Settings being done before installation is intentional
  
-  sudo -e '/etc/mysql/conf.d/custom.cnf'+  sudo -e '/etc/mysql/mariadb.conf.d/custom.cnf'
  
 <code> <code>
Line 28: Line 28:
 expire_logs_days = 7 expire_logs_days = 7
 max_binlog_size = 100M max_binlog_size = 100M
-skip-networking = On</code>+skip-networking = On 
 +table_definition_cache = 1400</code>
  
 ==== Verify ===== ==== Verify =====
Line 57: Line 58:
  
   FLUSH PRIVILEGES;   FLUSH PRIVILEGES;
 +
 +  EXIT
  
 ===== Authentication File ===== ===== Authentication File =====
Line 77: 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='/usr/bin/sync'</code>+ExecStartPost='/bin/sync'</code>
  
 ===== Timer ===== ===== Timer =====
/var/www/wiki/data/pages/servers/mariadb.txt · Last modified: 2024/03/06 21:01 by Sean Rhone