#   -------------------------------------------------------------
#   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