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