my.cnf
ActivePublic
Actions

Authored by dereckson on Nov 5 2017, 01:55.

Tags

None

Referenced Files

	F548652: /usr/local/etc/my.cnf
	Nov 5 2017, 01:55

Subscribers

None

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

/usr/local/etc/my.cnfActivePublicActions

Event Timeline

/usr/local/etc/my.cnf
ActivePublic
Actions