Celeron 2,8 1gb ram ayarlardan pek anlamam biyerlerde bu ayarları bulmuştum bunları kullanıyorum. doğrumu yapıyorum. bilmem bazen ani yüklenmeler ve kilitenmeler oluyor. bu ayarları yapmadan önce daha az hitte daha çok kilitlenme oluyordu. serverın aldığı max hit 4-6k arası.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=25
max_connections=300
interactive_timeout=5
wait_timeout=5
connect_timeout=5
thread_cache_size=64
key_buffer=256M
join_buffer=1M
max_allowed_packet=64M
table_cache=512
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=32M
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
top - 12:52:36 up 27 days, 17:25, 1 user, load average: 1.54, 1.65, 1.52
Tasks: 200 total, 2 running, 196 sleeping, 1 stopped, 1 zombie
Cpu(s): 19.5% us, 4.3% sy, 0.0% ni, 75.9% id, 0.3% wa, 0.0% hi, 0.0% si
Mem: 969588k total, 769528k used, 200060k free, 67760k buffers
Swap: 1966072k total, 131688k used, 1834384k free, 352420k cached
PID USER
PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1268 oyunsonu 21 0 20704 10m 3736 R 10.6 1.1 0:00.32 php
883 mysql 16 0 301m 36m 2476 S 4.0 3.9 0:58.80 mysqld
1266 root 16 0 3560 1024 760 R 0.7 0.1 0:00.03 top
1 root 16 0 2020 440 412 S 0.0 0.0 0:01.96 init
2 root 34 19 0 0 0 S 0.0 0.0 0:00.50 ksoftirqd/0
3 root 5 -10 0 0 0 S 0.0 0.0 0:03.95 events/0
4 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
5 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
26 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
27 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
47 root 11 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
46 root 16 0 0 0 0 S 0.0 0.0 1:35.27 kswapd0
191 root 25 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
291 root 5 -10 0 0 0 S 0.0 0.0 0:00.07 ata/0
293 root 23 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
294 root 24 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
308 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 kmirrord
2.6.9-42.EL #1 Sat Aug 12 09:17:58 CDT 2006 i686 i686 i386 GNU/Linux