Difference between revisions of "/etc/mysql/mariadb.conf.d/50-server.cnf"

From wikieduonline
Jump to navigation Jump to search
m (Welcome moved page Etc/mysql/mariadb.conf.d/50-server.cnf to /etc/mysql/mariadb.conf.d/50-server.cnf without leaving a redirect)
Line 8: Line 8:
 
  port = 3306
 
  port = 3306
 
  basedir = /usr
 
  basedir = /usr
  datadir = [[/var/lib/]]mysql
+
  datadir = [[/var/lib/mysql]]
 
  tmpdir = /tmp
 
  tmpdir = /tmp
 
  lc-messages-dir = /usr/share/mysql
 
  lc-messages-dir = /usr/share/mysql

Revision as of 14:58, 17 April 2021

cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v "#" | grep .
[server]
[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
bind-address		= 127.0.0.1
key_buffer_size		= 16M 
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
myisam_recover_options  = BACKUP
query_cache_limit	= 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days	= 10 
max_binlog_size   = 100M
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
[embedded]
[mariadb]
[mariadb-10.1]

See also

Advertising: