# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
log-slow-queries=/var/lib/mysql/slow.log
skip-external-locking
bind-address = 127.0.0.1
skip-name-resolve
skip-locking
skip-innodb
max_connections=150
max_user_connections=100
key_buffer_size = 10G
thread_cache_size = 50
query_cache_size = 128M
query_cache_limit = 4M
tmp_table_size = 48M
max_heap_table_size = 48M
default-storage-engine = myisam
table_open_cache = 5000
table_cache = 5000
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16M
[myisamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=16M
write_buffer=16M
Partager