Hello all, I'm trying to speed up Koha 3.8 by enabling memcached, following the instructions in the wiki (http://wiki.koha-community.org/wiki/Performance). But I found that OPAC search performance is almost unchanged with memcached enabled. By looking at memcached stats and MySQL query log, it seems like memcached is only used to store Koha's config (koha-conf.xml). The query to MySQL is exactly the same with or with out memcached. I suppose that once memcached is enabled, all preferences should be read from memcached instead? Is there anything else I should do to get memcached fully working with Koha? FYI, I'm running Koha 3.8.5 on Ubuntu 12.04 using koha-common package. Thank you, Pongtawat
Hi, On Fri, Oct 12, 2012 at 11:32 AM, Pongtawat Chippimolchai <pongtawat.c@gmail.com> wrote:
By looking at memcached stats and MySQL query log, it seems like memcached is only used to store Koha's config (koha-conf.xml). The query to MySQL is exactly the same with or with out memcached. I suppose that once memcached is enabled, all preferences should be read from memcached instead? Is there anything else I should do to get memcached fully working with Koha?
Memcached can also be used to store user sessions, and although doing that is not a panacea, I've observed that it can noticeably improve responsiveness. To enable this, set the SessionStorage syspref to use memcached. Regards, Galen -- Galen Charlton Director of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
Dear Galen, Thank you. I will try to set that preference. But how about the preferences themselves? Are they normally stored in memcached as well, once enabled in Apache config? Regards, Pongtawat On ส. 13 ต.ค. 2555, 00:40:32, Galen Charlton wrote:
Hi,
On Fri, Oct 12, 2012 at 11:32 AM, Pongtawat Chippimolchai <pongtawat.c@gmail.com> wrote:
By looking at memcached stats and MySQL query log, it seems like memcached is only used to store Koha's config (koha-conf.xml). The query to MySQL is exactly the same with or with out memcached. I suppose that once memcached is enabled, all preferences should be read from memcached instead? Is there anything else I should do to get memcached fully working with Koha?
Memcached can also be used to store user sessions, and although doing that is not a panacea, I've observed that it can noticeably improve responsiveness. To enable this, set the SessionStorage syspref to use memcached.
Regards,
Galen
Hi, On Sun, Oct 14, 2012 at 10:17 PM, Pongtawat Chippimolchai <pongtawat.c@gmail.com> wrote:
Thank you. I will try to set that preference. But how about the preferences themselves? Are they normally stored in memcached as well, once enabled in Apache config?
No, system preferences aren't currently cached in memcached. Regards, Galen -- Galen Charlton Director of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
Dear Galen, Thank you for information. I'm a little bit curious why prefs are not cached? Loading them seem to take many round trips to MySQL. Regards, Pongtawat On อ. 16 ต.ค. 2555, 01:19:53, Galen Charlton wrote:
Hi,
On Sun, Oct 14, 2012 at 10:17 PM, Pongtawat Chippimolchai <pongtawat.c@gmail.com> wrote:
Thank you. I will try to set that preference. But how about the preferences themselves? Are they normally stored in memcached as well, once enabled in Apache config?
No, system preferences aren't currently cached in memcached.
Regards,
Galen
On 16 October 2012 22:03, Pongtawat Chippimolchai <pongtawat.c@gmail.com> wrote:
Dear Galen,
Thank you for information.
I'm a little bit curious why prefs are not cached? Loading them seem to take many round trips to MySQL.
Memcached is for scalability not speed, fetching the prefs from memcached is actually slower than fetching them mysql, unless your database is under severe load. (We benchmarked them). If you run Koha under plack (which you can do with a bit of set up from 3.8.x on), the preferences are cached in persistent variables, there is obviously a huge improvement with that. Chris
Dear Chris, This is clear to me now. Thank you very much. I'm currently trying to setup Koha on Plack as well :) Regards, Pongtawat On อ. 16 ต.ค. 2555, 16:07:32, Chris Cormack wrote:
On 16 October 2012 22:03, Pongtawat Chippimolchai <pongtawat.c@gmail.com> wrote:
Dear Galen,
Thank you for information.
I'm a little bit curious why prefs are not cached? Loading them seem to take many round trips to MySQL.
Memcached is for scalability not speed, fetching the prefs from memcached is actually slower than fetching them mysql, unless your database is under severe load. (We benchmarked them). If you run Koha under plack (which you can do with a bit of set up from 3.8.x on), the preferences are cached in persistent variables, there is obviously a huge improvement with that.
Chris
participants (3)
-
Chris Cormack -
Galen Charlton -
Pongtawat Chippimolchai