Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
yacenty Posted September 17, 2009 Posted September 17, 2009 Hello, Yesterday I had notticed over 600 QPS on my mysql server so I'm thinking about replication of the mysql server. Have You got experiences with this? Is IPB prepared for such funtionality? How to make mysql performance much bigger? - tweaks were done so next step is relativelly going to new server or maybe replication of DB into 2 servers to make performance bigger. Do You have any hints?
Velvet Elvis Posted September 17, 2009 Posted September 17, 2009 I haven't needed to go the replication route, but using memcached with just the default debian settings made a huge difference in my database load. Give it a try if you haven't.
yacenty Posted September 17, 2009 Author Posted September 17, 2009 I'm already using xcache isn't it same functionality?
yacenty Posted September 17, 2009 Author Posted September 17, 2009 could You give some details,, hints how to follow this operation?
Velvet Elvis Posted September 19, 2009 Posted September 19, 2009 I'm also running APC. Memcached is not the same thing as an opcode cache. It directly caches database queries, more like mysql's query cache. I installed the package from the debian archive with 'sudo aptitude install memcached.' I kept all the default settings in /etc/memcached.conf. If you have buckets of memory to spare you might want to consider raising the value for -m, but otherwise I'd leave everything as is. I added the following to conf_global.php in the IPB root directory. $INFO['use_memcache'] = 1; $INFO['memcache_server_1'] = "127.0.0.1"; $INFO[memcache_port_1'] = "11211";
yacenty Posted September 19, 2009 Author Posted September 19, 2009 so Are You using both? apc and memcache?
Velvet Elvis Posted September 20, 2009 Posted September 20, 2009 Yes. One caches complied php and the other mysql queries. They do completely different things.
yacenty Posted September 21, 2009 Author Posted September 21, 2009 have You added memcache extension in php.ini config? or it's enabled only in global_conf.php?
yacenty Posted September 21, 2009 Author Posted September 21, 2009 one more question - how it's possible to monitor if memchache is runing OK, if there are any benefits, which hits are taken by xcache, which ones are taken by memcache and which by mysql? regards YacentY
Bono Posted September 22, 2009 Posted September 22, 2009 [quote name='Velvet Elvis' date='20 September 2009 - 07:55 AM' timestamp='1253426116' post='1857522'] Yes. One caches complied php and the other mysql queries. They do completely different things. How many queries per second have you saved with memcache? On my box it is not critical but it's always good to plan ahead, atm I got 163 QPS.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.