Optymalizacja pliku my.cfn Opcje

[XQS]

Witam!

Mam VPS pod forum.

2Ghz CPU
2GB Gwar/ 4GB Brust - RAM

Zainstalowane lighttpd i mysql 5.1
System: Debian 5 64bit
Baza ma okolo 550mb

Chciałbym zoptymalizować moj my.cfn pod moje ustawienia.

Kod

[mysqld_safe]
socket        = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]
#
# * Basic Settings
#
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
skip-external-locking

bind-address        = 127.0.0.1
#
# * Fine Tuning
#
key_buffer        = 128M
max_allowed_packet    = 16M
thread_stack        = 192K
thread_cache_size       = 32

myisam-recover         = BACKUP
#max_connections        = 100
table_cache            = 512
#thread_concurrency     = 10

query_cache_limit    = 1M
query_cache_size        = 64M

# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1

# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.

#log_slow_queries    = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

#server-id        = 1
#log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days    = 10
max_binlog_size         = 100M
#binlog_do_db        = include_database_name
#binlog_ignore_db    = include_database_name

# * InnoDB

# chroot = /var/lib/mysql/

# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet    = 16M

[mysql]
#no-auto-rehash    # faster start of mysql but no tab completition

[isamchk]
key_buffer= 64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

!includedir /etc/mysql/conf.d/

Czy takie ustawienia mogą być ? Czy coś zmienić, zależy mi na wydajnosci. narazie zajete mam 600 RAM

Ten post edytował XQS 11.05.2011, 20:31:43