Darkdream said:In phpMyAdmin findest du, wenn du als root eingeloggt bist, alle Statusvariablen. Du siehst sofort, wo du Optimierungen vornehmen kannst, da diese Werte rot dargestellt sind.
Wenn du google ein wenig quälst, wirst du viele Beispielconfigurationen finden. Die Standardconfig ist für sehr schwache Server. Bei 2 gig Ram, kannst du einige Speicherwerte um einiges erhöhen.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file=/var/run/mysqld/mysqld.pid
skip-innodb
skip-locking
safe-show-database
max_connections = 500
key_buffer = 512M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 512
thread_cache_size = 256
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 32M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
max_allowed_packet=64M
wait_timeout=3600
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
open_files_limit = 8192
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/mysql-slow
[mysqldump]
quick
max_allowed_packet = 32M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
top - 23:02:30 up 4 days, 4:14, 1 user, load average: 2.35, 3.41, 3.28
Tasks: 143 total, 1 running, 142 sleeping, 0 stopped, 0 zombie
Cpu(s): 61.5% us, 11.8% sy, 0.0% ni, 19.8% id, 6.3% wa, 0.2% hi, 0.5% si
Mem: 2009456k total, 1787936k used, 221520k free, 6444k buffers
Swap: 530136k total, 11032k used, 519104k free, 842056k cached
We use essential cookies to make this site work, and optional cookies to enhance your experience.