[ASK + Saran] Setingan Apace+mysql yang jos buat Dedi Server

Beranda

...

Hosting Stuff
[ASK + Saran] Setingan Apace+mysql yang jos buat Dedi Server

andrypein

23-04-2016 14:17

[ASK + Saran] Setingan Apace+mysql yang jos buat Dedi Server

assalamualaikum wr wb

A. Intro
1. spek nya : Rainer intel Xeon 8core, RAM 8GB
2. cm buat 1 webset wodpres dengan 45rb pos
3. dipasang di colocasion dgn benwit 30Mbps

B. Kasus
1. dikasih 100 visitor langsung down timeout :v
2. ane htop, RAM usage cuma 1.5GB an dengan Max usage 3GB

C. langsung ke intinya aja
1. udah pasti konfigan apache.conf, php.ini , dn my.cnf ane salah
2. kira2 dengan spek mesin segitu plus harus handle 10k visitor, setingan apacemysql yang bener nya gimana sih gan?

D. ini ane sertain Konfig apace + mysql nya

Spoiler for apace:

Code:





Mutex file:${APACHE_LOCK_DIR} default



PidFile ${APACHE_PID_FILE}



Timeout 50



KeepAlive Off





MaxKeepAliveRequests 1000



KeepAliveTimeout 5





User ${APACHE_RUN_USER}

Group ${APACHE_RUN_GROUP}



HostnameLookups Off





ErrorLog ${APACHE_LOG_DIR}/error.log



LogLevel warn





IncludeOptional mods-enabled/*.load

IncludeOptional mods-enabled/*.conf



Include ports.conf



AccessFileName .htaccess



LogFormat "%v:%p %h %l %u %t "%r" %>s %O "%{Referer}i" "%{User-Agent}i"" vhost_combined

LogFormat "%h %l %u %t "%r" %>s %O "%{Referer}i" "%{User-Agent}i"" combined

LogFormat "%h %l %u %t "%r" %>s %O" common

LogFormat "%{Referer}i -> %U" referer

LogFormat "%{User-agent}i" agent



<IfModule mpm_prefork_module>

 StartServers 1

 MinSpareServers 5

 MaxSpareServers 10

 MaxClients 50

 MaxRequestsPerChild 3000

</IfModule>

Spoiler for mysql:

Code:





[mysqld]



symbolic-links = 0

innodb_file_per_table = 1

thread_concurrency = 8

query_cache_size = 64M

query_cache_limit = 4M

thread_cache_size = 8

myisam_sort_buffer_size = 64M

read_rnd_buffer_size = 8M

read_buffer_size = 2M

sort_buffer_size = 2M

table_cache = 1600

table_definition_cache = 1600

max_allowed_packet = 4M

key_buffer = 1G

interactive_timeout = 2

wait_timeout = 5

long_query_time = 1

log_slow_queries = ON

open_files_limit = 3200

innodb_buffer_pool_size = 26M

join_buffer_size = 4M

tmp_table_size = 72M

max_heap_table_size = 72M

max_connections = 80