Page MenuHomeDevCentral
Paste P268

/usr/local/etc/my.cnf
ActivePublic

Authored by dereckson on Nov 5 2017, 01:55.
# -------------------------------------------------------------
# MySQL configuration
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# Project: Nasqueron
# Created: 2015-04-21
# License: Trivial work, not eligible to copyright
# -------------------------------------------------------------
# -------------------------------------------------------------
# Client
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysql]
prompt = \u@\h [\d]>\_
# -------------------------------------------------------------
# Server wrapper
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
nice = 0
# -------------------------------------------------------------
# Generic server settings
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp
datadir = /var/db/mysql/mysql-root
# -------------------------------------------------------------
# InnoDB / XtraDB configuration
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
innodb_buffer_pool_size = 410M
innodb_data_home_dir = /var/db/mysql/mysql-innodb-data
innodb_log_group_home_dir = /var/db/mysql/mysql-innodb-logs
skip-innodb_doublewrite
# -------------------------------------------------------------
# Applications configuration
#
# :: Phabricator
# :: OTRS
#
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# Phabricator
sql_mode = STRICT_ALL_TABLES
max_allowed_packet = 33554432
ft_stopword_file = /usr/local/etc/mysql/stopwords.txt
ft_min_word_len = 3
ft_boolean_syntax = ' |-><()~*:""&^'
# OTRS
key_buffer_size = 32M

Event Timeline

dereckson edited the content of this paste. (Show Details)Nov 5 2017, 01:55
dereckson changed the title of this paste from untitled to /usr/local/etc/my.cnf.
dereckson updated the paste's language from autodetect to autodetect.

File created by D1122.