Difference between revisions of "/etc/mysql/mariadb.conf.d/50-server.cnf"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
Tags: Mobile web edit, Mobile edit |
||
| Line 1: | Line 1: | ||
| − | + | ||
cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v "#" | grep . | cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v "#" | grep . | ||
| − | [server] | + | [server] |
| − | [mysqld] | + | [mysqld] |
| − | user = mysql | + | user = mysql |
| − | pid-file = /var/run/mysqld/mysqld.pid | + | pid-file = /var/run/mysqld/mysqld.pid |
| − | socket = /var/run/mysqld/mysqld.sock | + | socket = /var/run/mysqld/mysqld.sock |
| − | 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 |
| − | skip-external-locking | + | skip-external-locking |
| − | bind-address = 127.0.0.1 | + | bind-address = 127.0.0.1 |
| − | key_buffer_size = 16M | + | key_buffer_size = 16M |
| − | max_allowed_packet = 16M | + | max_allowed_packet = 16M |
| − | thread_stack = 192K | + | thread_stack = 192K |
| − | thread_cache_size = 8 | + | thread_cache_size = 8 |
| − | myisam_recover_options = BACKUP | + | myisam_recover_options = BACKUP |
| − | query_cache_limit = 1M | + | query_cache_limit = 1M |
| − | query_cache_size = 16M | + | query_cache_size = 16M |
| − | log_error = /var/log/mysql/error.log | + | log_error = /var/log/mysql/error.log |
| − | expire_logs_days = 10 | + | expire_logs_days = 10 |
| − | max_binlog_size = 100M | + | max_binlog_size = 100M |
| − | character-set-server = utf8mb4 | + | character-set-server = utf8mb4 |
| − | collation-server = utf8mb4_general_ci | + | collation-server = utf8mb4_general_ci |
| − | [embedded] | + | [embedded] |
| − | [mariadb] | + | [mariadb] |
| − | [mariadb-10.1] | + | [mariadb-10.1] |
| − | |||
== See also == | == See also == | ||
* {{MariaDB}} | * {{MariaDB}} | ||
Revision as of 17:32, 27 May 2020
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
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files:.frm,.ibd,/etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries,show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306,/etc/mysql/
Advertising:
