nobody
04-21-2005, 10:59 PM
Anybody have some configurations for both apache and mysql that would do well on high traffic (both MySQL and apache) websites for a VPS? There are a lot of suggestions for dedicated servers but quite little for a VPS. Some options apply equally but some do not so anyway, please share if you know any.
My looks like this:
[mysqld]
skip-locking
max_connections=300
connect_timeout=15
key_buffer=16M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
table_cache=1028
thread_cache_size=286
max_allowed_packet=5M
wait_timeout=15
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
thread_concurrency=2
It's pretty short since I'm not familiar with the rest of the functions. As for apache,
Timeout 300
KeepAlive On
MaxKeepAliveRequests 10000
KeepAliveTimeout 5
MinSpareServers 15
MaxSpareServers 35
StartServers 15
MaxClients 150
MaxRequestsPerChild 0
Any comments/ratings on configurations shared are welcome (hope people don't mind).
My looks like this:
[mysqld]
skip-locking
max_connections=300
connect_timeout=15
key_buffer=16M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
table_cache=1028
thread_cache_size=286
max_allowed_packet=5M
wait_timeout=15
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
thread_concurrency=2
It's pretty short since I'm not familiar with the rest of the functions. As for apache,
Timeout 300
KeepAlive On
MaxKeepAliveRequests 10000
KeepAliveTimeout 5
MinSpareServers 15
MaxSpareServers 35
StartServers 15
MaxClients 150
MaxRequestsPerChild 0
Any comments/ratings on configurations shared are welcome (hope people don't mind).