Knowledgebase
Optimization?
Posted by y0uknight, 04-11-2009, 07:14 PM | I'm running a Xeon Quad Core 2.5GHz with 2GB RAM. Comments on my setup for shared hosting? (will upgrade ram if people believe that will help with increase page loadtimes.)
XCACHE:
xcache.shm_scheme = "mmap"
xcache.size = 64M
xcache.count = 5
xcache.slots = 16K
xcache.ttl = 3600
xcache.gc_interval = 7200
xcache.var_size = 64M
xcache.var_count = 5
xcache.var_slots = 16K
xcache.var_ttl = 3600
xcache.var_maxttl = 7200
xcache.var_gc_interval = 300
xcache.test = Off
xcache.readonly_protection = Off
xcache.mmap_path = "/dev/zero"
xcache.coredump_directory = ""
xcache.cacher = On
xcache.stat = On
xcache.optimizer = On
MySQL:
[mysqld]
set-variable = max_connections=500
safe-show-database
old-passwords = 1
skip-networking
skip-name-resolve
skip-external-locking
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 5120
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
read_rnd_buffer_size=8M
myisam_sort_buffer_size=64M
thread_cache_size=8
thread_cache=256
query_cache_limit=12M
query_cache_size=512M
thread_concurrency = 8
wait_timeout=120
connect_timeout=30
long_query_time=5
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
|
Posted by qixxiq, 04-11-2009, 08:09 PM | It would depend a lot on what type of websites (and/or databases your clients are hosting). Generally a good idea is to see if you can find any bottlenecks on a running system - and then see if its possible to reduce them with configuration changes.
Upgrading the RAM is useless unless that RAM is used. If you're currently not using all of it, then its not really worth it -- although any unused ram can always be used as cache so...
|
Posted by y0uknight, 04-12-2009, 12:31 PM | I highly doubt I'll have bottle necks, but how can I check? Basically, I've got about 500MB of RAM not being used, so I'm just wondering if I should raise the cache limits to increase page load times.
|
Posted by lemeneid, 04-12-2009, 01:07 PM | xcache config looks fine but your mysql needs more tuning. that will prob be your bottleneck along with your ram. you'll need lots of ram if you want to do hosting.
|
|
Add to Favourites
Print this Article |
Also Read