Probably you have any advice on adjustment my.cnf
From time to time there are problems at hi loadings
-----
CPU: 4 x Xeon 7330 (Quad Core)
RAM: 32Gb
HDD: SAS 10K prm
-----
2200 Users online in 600 sec
database: 14Gb
-----
Used:
xcashe 1.2.1
Apache v2.2.4
PHP 5.2.3
Mysql 5.0.45
Ubuntu 7..
------
--my.cnf--
max_connections = 10000
max_connect_errors = 1000000
connect_timeout = 10
wait_timeout = 28800
Web Server Optimization Guide | 站長手扎::
1. Basic Config File Editing Make a backup of your /etc/my.cnf file, and then perform the following via SSH: pico /etc/my.cnf Add in the following
http://blog.saycoo.com/archives/14HOME |
open_files_limit = 20000
table_cache = 20000
tmp_table_size = 1024M
max_heap_table_size = 256M
key_buffer_size = 4096M
max_allowed_packet = 16M
thread_stack = 256K
thread_cache_size = 200
thread_concurrency = 20
query_cache_limit = 64M
query_cache_size = 1024M
query_cache_type = 1
skip-bdb
skip-innodb
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 1024M
-- // --
Thank you!
top.
---
after 5 days work (no hi load)
top - 11:01:01 up 5 days, 21:21, 1 user, load average: 1.25, 1.08, 0.98
Tasks: 539 total, 2 running, 537 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.1%us, 0.1%sy, 0.0%ni, 95.5%id, 0.2%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 33009036k total, 32652608k used, 356428k free, 853124k buffers
Swap: 0k total, 0k used, 0k free, 22011976k cached
after reboot
top - 11:47:25 up 25 min, 1 user, load average: 0.40, 1.12, 1.20
Tasks: 1139 total, 1 running, 1137 sleeping, 0 stopped, 1 zombie
Cpu(s): 6.0%us, 1.7%sy, 0.0%ni, 87.8%id, 4.4%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 33009036k total, 20408916k used, 12600120k free, 80680k buffers
Swap: 0k total, 0k used, 0k free, 16451344k cached
need alot more info as asked at http://www.vbulletin.com/forum/showthread.php?t=70117
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market
|
My.cnf optimization request