elég komoly a weblap, egyébként egy fizetős cms-el megy (expressionengine)
I/O waiting ugrándozik 0 és max 12% között, olyan átlag 3-5%
memcached van RAID nincs, ja és még van eAccelerator
4,5millió oldalletöltés óránként, a lekérdezések számát nem tudom.
adatbázis 150MB
Mysql beállítások:
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
character-set-server=utf8
collation-server=utf8_general_ci
default-character-set = utf8
default-collation = utf8_general_ci
init_connect='SET character_set_connection = utf8;set collation_connection = utf8_general_ci; set character_set_client= utf8; set character_set_results= utf8;'
skip-external-locking
bind-address = localhost
key_buffer = 1024M
max_allowed_packet = 16M
thread_stack = 4M
thread_cache_size = 100
myisam-recover = BACKUP
max_connections = 100
table_cache = 2048
join_buffer_size = 8M
query_cache_limit = 2M
query_cache_size = 64M
log_slow_queries = /var/log/mysql/mysql-slow.log
expire_logs_days = 10
max_binlog_size = 100M
connect_timeout = 15
interactive_timeout = 100
myisam_sort_buffer_size = 64M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
sort_buffer_size = 4M
thread_concurrency = 4
wait_timeout = 200
query_cache_type=1
fcgid conf:
AddHandler fcgid-script .php .php5
AddHandler fcgid-script .fcgi .php
# Where to look for the php.ini file?
DefaultInitEnv PHPRC "/etc/php5/cgi"
# Maximum number of requests each process should handle before it is terminated
MaxRequestsPerProcess 1000
# Maximum number of processes to spawn
MaxProcessCount 50
# Number of seconds of idle time before a php-cgi process is terminated
IPCCommTimeout 60
IdleTimeout 60
# Executable to run
FCGIWrapper /usr/bin/php-cgi .php
# Limits on Apache processes itself