Recently my server started to act weird and is getting too much server load and the ram is used only 30 to 40 percent max below are my configurations hope someone with more knowledge can help me to optimize the server. I've searched the forum and followed some suggestion that have posted PowerChaos but i think it need to be tweaked some values, right now the file server is on the same machine with the script but in a few days i'll transfer it on a separate server and the file server will be with nginx mode
Server configuration is
Intel(R) Core(TM) i7 CPU 950 @ 3.07GHz (8 processors)
24GB Ram
1TB Hard Disk
here is the httpd.conf
Code: Select all
Timeout 30
TraceEnable Off
ServerSignature Off
ServerTokens ProductOnly
FileETag None
StartServers 5
<IfModule prefork.c>
MinSpareServers 5
MaxSpareServers 10
</IfModule>
ServerLimit 500
MaxClients 350
MaxRequestsPerChild 5000
KeepAlive Off
KeepAliveTimeout 10
MaxKeepAliveRequests 5
Code: Select all
#DO NOT MODIFY THE FOLLOWING COMMENTED LINES!
#els-build=5.0
[mysqld]
bind-address = 127.0.0.1
slow-query-log = 1
slow_query_log_file = /var/log/mysql.slow-queries.log
open-files-limit = 32000
local-infile=0
datadir=/var/lib/mysql
skip-locking
#skip-innodb
#skip-networking
safe-show-database
query_cache_limit=4M
query_cache_size=256M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=350
max_connections=750
interactive_timeout=45
wait_timeout=30
connect_timeout=15
thread_cache_size=256
key_buffer=320M ## 128MB for every 1GB of RAM
join_buffer=6M
max_connect_errors=10
max_allowed_packet=6M
table_cache=2048
record_buffer=4M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=4M
server-id=1
collation-server=latin1_general_ci
join_buffer_size=6M
tmp_table_size=100M
max_heap_table_size=80M
#log_slow_queries=/var/log/mysql-slow.log
long_query_time=10
#log-queries-not-using-indexes
[mysql.server]
user=mysql
[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
[mysql]
#no-auto-rehash
#safe-updates
#[isamchk]
#key_buffer=64M
#sort_buffer=64M
#read_buffer=16M
#write_buffer=16M
[myisamchk]
#key_buffer=64M
#sort_buffer=64M
#read_buffer=16M
#write_buffer=16M
#[mysqlhotcopy]
#interactive-timeout