my.cnf kendine göre ayarla
Alıntı
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking # 1 mysql varsa
skip-innodb # innodb kullanilmiyorsa
key_buffer = 768M # 1Gb bellek icin 384M, 512Mb icin 192M
table_cache = 512
max_connections = 600
query-cache-type = 1 # query cache mysql i hizlandirir, 1=acik
query-cache-size = 32M # kullanilacak query cache miktari
max_allowed_packet=64M # mysqlhotcopy icin
wait_timeout=3600 # mysqlhotcopy icin
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
open_files_limit=18192
[mysqldump]
quick
max_allowed_packet=32M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32M
write_buffer=32M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32M
write_buffer=32M
MySQL AB :: MySQL Presentations: Optimizing MySQL