Created
September 8, 2011 04:03
-
-
Save hdemon/1202580 to your computer and use it in GitHub Desktop.
my.cnf / 5.5
This file contains 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
[client] | |
#password = your_password | |
port = 3306 | |
#socket = /tmp/mysql.sock | |
socket = /var/run/mysqld/mysqld.sock | |
default-character-set = utf8 | |
[mysqld] | |
port = 3306 | |
#socket = /tmp/mysql.sock | |
socket = /var/run/mysqld/mysqld.sock | |
basedir = /usr/local/mysql | |
datadir = /usr/local/mysql/data | |
tmpdir = /tmp | |
log_error = /var/log/mysql/error.log | |
slow-query-log = ON | |
slow-query-log-file = /var/log/mysql/slow.log | |
skip-external-locking | |
key_buffer_size = 16M | |
max_allowed_packet = 1M | |
table_open_cache = 64 | |
sort_buffer_size = 512K | |
net_buffer_length = 8K | |
read_buffer_size = 256K | |
read_rnd_buffer_size = 512K | |
myisam_sort_buffer_size = 8M | |
#skip-networking | |
#log-bin=mysql-bin | |
#binlog_format=mixed | |
server-id = 1 | |
#server-id = 2 | |
#master-host = <hostname> | |
#master-user = <username> | |
#master-password = <password> | |
#master-port = <port> | |
#log-bin=mysql-bin | |
#innodb_data_home_dir = /usr/local/mysql/data | |
#innodb_data_file_path = ibdata1:10M:autoextend | |
#innodb_log_group_home_dir = /usr/local/mysql/data | |
# You can set .._buffer_pool_size up to 50 - 80 % | |
# of RAM but beware of setting memory usage too high | |
#innodb_buffer_pool_size = 16M | |
#innodb_additional_mem_pool_size = 2M | |
# Set .._log_file_size to 25 % of buffer pool size | |
#innodb_log_file_size = 5M | |
#innodb_log_buffer_size = 8M | |
#innodb_flush_log_at_trx_commit = 1 | |
#innodb_lock_wait_timeout = 50 | |
[mysqldump] | |
quick | |
max_allowed_packet = 16M | |
[mysql] | |
no-auto-rehash | |
# Remove the next comment character if you are not familiar with SQL | |
#safe-updates | |
[myisamchk] | |
key_buffer_size = 20M | |
sort_buffer_size = 20M | |
read_buffer = 2M | |
write_buffer = 2M | |
[mysqlhotcopy] | |
interactive-timeout | |
[mysqld_safe] | |
basedir = /usr/local/mysql |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment