Created
February 7, 2014 20:40
-
-
Save byllc/8871383 to your computer and use it in GitHub Desktop.
Example Maria DB Config file (.my.cnf)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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