selamlar,
4 GB RAM ve 1 adet quadcore işlemcisi olan bir sistem üzerine Centos 5.1 e
sahip ve sadece mysql olarak hizmet verecek bir mysql 5.0 sunucu üzerindeki
aşağıdaki optimizasyon konusundaki düşüncelerini benimla paylaşır mısın?
"mysql_ayirmak_istediginiz_memory = key_buffer + {
(sort_buffer_size+read_buffer_size) * max_connections }"
baz alınarak hazırlanmıştır.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=0
bind-address=127.0.0.1
max_connections=300
# Set MyISAM parameters
key_buffer_size=512M
tmp_table_size=16M
# Set InnoDB parameters
innodb_file_per_table
# Set buffer pool size to 50 - 80% of availiable memory.
innodb_buffer_pool_size=1000M
innodb_additional_mem_pool_size=50M
# Set the log file size to about 25% of the buffer pool size.
innodb_log_file_size=5M
innodb_log_buffer_size=1M
table_cache=1024
sort_buffer_size=4M
read_buffer_size=4M
query_cache_type=1
query_cache_limit=1M
query_cache_size=40M
net_read_timeout=120
long_query_time=10
log_warnings=2
log_slow_queries=/var/log/mysql/slow-queries.log
collation_server=utf8_unicode_ci
character_set_server=utf8
[mysql]
default-character-set=utf8
[mysqldump]
default-character-set=utf8
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
İyi çalışmalar...
Mesut GÜLNAZ
