yacenty Posted September 17, 2009 Share 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? Link to comment Share on other sites More sharing options...
Velvet Elvis Posted September 17, 2009 Share 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. Link to comment Share on other sites More sharing options...
yacenty Posted September 17, 2009 Author Share Posted September 17, 2009 I'm already using xcache isn't it same functionality? Link to comment Share on other sites More sharing options...
yacenty Posted September 17, 2009 Author Share Posted September 17, 2009 could You give some details,, hints how to follow this operation? Link to comment Share on other sites More sharing options...
Velvet Elvis Posted September 19, 2009 Share 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"; Link to comment Share on other sites More sharing options...
yacenty Posted September 19, 2009 Author Share Posted September 19, 2009 so Are You using both? apc and memcache? Link to comment Share on other sites More sharing options...
Velvet Elvis Posted September 20, 2009 Share Posted September 20, 2009 Yes. One caches complied php and the other mysql queries. They do completely different things. Link to comment Share on other sites More sharing options...
yacenty Posted September 21, 2009 Author Share Posted September 21, 2009 have You added memcache extension in php.ini config? or it's enabled only in global_conf.php? Link to comment Share on other sites More sharing options...
yacenty Posted September 21, 2009 Author Share 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 Link to comment Share on other sites More sharing options...
Bono Posted September 22, 2009 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.