Hi,
Lately my website on my vps is loading slow. It takes several seconds to load a page with no or just a few small images. I upgraded from 512mb to 768mb, and the swapping issue is taking care of. However webpages still loading slow when about 25 people online at the same time.
So I thought perhaps I have to tweak /apache2.conf and /my.cnf
** The current settings of apache2.conf are **
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 10
<IfModule mpm_prefork_module>
StartServers 10
MinSpareServers 1
MaxSpareServers 4
ServerLimit 25
MaxClients 25
MaxRequestsPerChild 500
</IfModule>
<IfModule mpm_worker_module>
StartServers 2
MinSpareThreads 25
MaxSpareThreads 75
ThreadLimit 64
ThreadsPerChild 25
MaxClients 150
MaxRequestsPerChild 0
</IfModule>
<IfModule mpm_event_module>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadLimit 64
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
<Files ~ ".ht">
Order allow,deny
Deny from all
</Files>
** And my my.cnf settings are **
key_buffer = 16K
max_allowed_packet = 1MB
thread_stack = 64K
thread_cache_size = 4
sort_buffer = 64K
net_buffer_length = 2K
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
query_cache_limit = 1M
query_cache_size = 32M
expire_logs_days = 10
max_binlog_size = 100M
I have an average of 1000 visitors a day on the vps, with about 12000 pageviews in approximately 18hours (it is not an English website, so located at one country)
I hope somebody will give me some directions ...
Thanks,
Christophe