[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 ]

skycrew

bump satu

st.yeepi

Kengkadang masalah nie datang dari script, cuba check configuration script blog hang tu, try enable/disable Persistent Database Connections jika ada. Aku dah lama tak godek godek server nie, so tak dapat lah nak bantu bebanyak, otak dah karat

Btw, php setting pun jgn lupa nak check

skycrew

tq utk input anda, nanti aku check