Skip to content

Instantly share code, notes, and snippets.

@byllc
Created February 7, 2014 20:40
Show Gist options
  • Save byllc/8871383 to your computer and use it in GitHub Desktop.
Save byllc/8871383 to your computer and use it in GitHub Desktop.
Example Maria DB Config file (.my.cnf)
# Example mysql config file.
# You can copy this to one of:
# /etc/my.cnf to set global options,
# /mysql-data-dir/my.cnf to get server specific options or
# ~/my.cnf for user specific options.
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# This will be passed to all mysql clients
[client]
#password=my_password
#port=3306
#socket=/tmp/mysql.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
#port=3306
#socket=/tmp/mysql.sock
temp-pool
# The following three entries caused mysqld 10.0.1-MariaDB (and possibly other versions) to abort...
# skip-locking
# set-variable = key_buffer=16M
# set-variable = thread_cache=4
loose-innodb_data_file_path = ibdata1:1000M
loose-mutex-deadlock-detector
gdb
######### Fix the two following paths
# Where you want to have your database
data=/path/to/data/dir
# Where you have your mysql/MariaDB source + sql/share/english
language=/path/to/src/dir/sql/share/english
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[myisamchk]
set-variable= key_buffer=128M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment