[HELP] MySQL Config (my.cnf)

skycrew

ni yg my.cnf aku gune skang ni

1. [mysqld]
   
2. port            = ****
   
3. socket          = /var/lib/mysql/mysql.sock
   
4. skip-locking
   
5. key_buffer = 16K
   
6. max_allowed_packet = 1M
   
7. table_cache = 4
   
8. sort_buffer_size = 64K
   
9. read_buffer_size = 256K
   
10. read_rnd_buffer_size = 256K
    
11. net_buffer_length = 2K
    
12. thread_stack = 64K
    
13. skip-bdb
    
14. skip-innodb
    
15. 
    
16. [mysqldump]
    
17. quick
    
18. max_allowed_packet = 16M
    
19. 
    
20. [mysql]
    
21. no-auto-rehash
    
22. #safe-updates
    
23. 
    
24. [isamchk]
    
25. key_buffer = 8M
    
26. sort_buffer_size = 8M
    
27. 
    
28. [myisamchk]
    
29. key_buffer = 8M
    
30. sort_buffer_size = 8M
    
31. 
    
32. [mysqlhotcopy]
    
33. interactive-timeout

Copy the Code

RAM vps aku maximum - 320 MB

aku run 2 blog wordpress setiap satu lebih kurang 10k page view sehari.

jadi ok ke config yg mcm ni? pasal RAM aku selalunye akan habis. pelik bin ajaib

ni pulak process list



mintak tolong le kengkawan eh.

mod-mod sekalian, aku pacak thread nii kat sini dulu, pasal bod programming tu kurang manusia la kat situ

[ Last edited by  skycrew at 14-4-2008 01:03 PM ]

testas

command ni

mysql> SHOW STATUS LIKE '%key_read%';

tgk apa hasik kuar..

testas

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

tukar jadi 2Mb .. dua dua.. try la

anti_aktivis

Originally posted by skycrew at 15-4-2008 06:57 PM
ni yg my.cnf aku gune skang ni

[mysqld]
port            = ****
socket          = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buf ...

cuba disable plugin plugin wordpress yang tak penting especially statistic since 10k page view perday. Perghhhh 10k , jeles aku

skycrew

disable pun sudah gak, last choice, aku terpaksa separate database

aku host 2blog jadi 2database. load cpu ngan memory melampau. jadi satu database tu aku terpaksa host tempat lain, baru la load kurang

adeh @@