Koha Performance Issue
I'm building a new koha server to replace our old koha 3.0.0 with koha 16.5.4. The new server has better specs than the old one. Towards the end of my work I started doing some basic testing of the screens compared to the old system. I noticed the new system is slower (much slower) than our old 3.0 koha. Basically any screen is 5x to 10x slower on the new version of koha. That includes anything from searching to loading the landing page of the opac. I checked on some of the koha demo sites and also noticed they are quite slow. Has koha just become bloated over time or have I misconfigured something? I didn't build the original server, but I compared apache and mysql settings and didn't notice anything that the new install was missing. I tried using memcached but that did nothing useful as far as I noticed. Does anyone have any insite into speeding up koha performance? caching? etc? -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Performance-Issue-tp5905752.html Sent from the Koha-general mailing list archive at Nabble.com.
* rfblanchard (rfblanchard@hotmail.com) wrote:
I'm building a new koha server to replace our old koha 3.0.0 with koha 16.5.4. The new server has better specs than the old one. Towards the end of my work I started doing some basic testing of the screens compared to the old system. I noticed the new system is slower (much slower) than our old 3.0 koha. Basically any screen is 5x to 10x slower on the new version of koha. That includes anything from searching to loading the landing page of the opac. I checked on some of the koha demo sites and also noticed they are quite slow. Has koha just become bloated over time or have I misconfigured something?
I didn't build the original server, but I compared apache and mysql settings and didn't notice anything that the new install was missing. I tried using memcached but that did nothing useful as far as I noticed.
Does anyone have any insite into speeding up koha performance? caching? etc?
Koha now uses a database independent layer an ORM (Object relationship model). This allows (in theory) Koha to be run on different database engines, it also allows for more Object Oriented code, which a lot of people like. It does have the downside of being quite a bit slower than straight SQL though, this accounts for most of the slow down you are noticing. Did you install Koha via packages? If so, you will want to switch plack on sudo koha-plack --enable <instancename> sudo koha-plack --start <instancename> Then restart apache. You will want to set up memcache as well. To enable caching to occur. This should speed things up considerably. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
Out of curiosity, does the amount of RAM make a significant difference? I've been trying to troubleshoot performance issues because of both network lag at our location. In trying to optimize the page-load speed during checkout, I've also upped the serve RAM to from 1gig to 4gigs. While that obviously doesn't address actual network lag (eg. bad pings or lost packets) it can at least help me verify if the issue is with my Koha server or with the building network. We are in a leased building, and have no control over the network infrastructure, so if I can rule out the server as a speed hindrance, then I can restart the conversation with IT. Thanks, Martin Martin House martin.house@gmail.com www.martindhouse.com 704-996-0297 "An unexamined life is not worth living." On Mon, Oct 3, 2016 at 2:50 PM, Chris Cormack <chrisc@catalyst.net.nz> wrote:
* rfblanchard (rfblanchard@hotmail.com) wrote:
I'm building a new koha server to replace our old koha 3.0.0 with koha 16.5.4. The new server has better specs than the old one. Towards the end of my work I started doing some basic testing of the screens compared to the old system. I noticed the new system is slower (much slower) than our old 3.0 koha. Basically any screen is 5x to 10x slower on the new version of koha. That includes anything from searching to loading the landing page of the opac. I checked on some of the koha demo sites and also noticed they are quite slow. Has koha just become bloated over time or have I misconfigured something?
I didn't build the original server, but I compared apache and mysql settings and didn't notice anything that the new install was missing. I tried using memcached but that did nothing useful as far as I noticed.
Does anyone have any insite into speeding up koha performance? caching? etc?
Koha now uses a database independent layer an ORM (Object relationship model). This allows (in theory) Koha to be run on different database engines, it also allows for more Object Oriented code, which a lot of people like.
It does have the downside of being quite a bit slower than straight SQL though, this accounts for most of the slow down you are noticing.
Did you install Koha via packages? If so, you will want to switch plack on
sudo koha-plack --enable <instancename> sudo koha-plack --start <instancename>
Then restart apache. You will want to set up memcache as well. To enable caching to occur. This should speed things up considerably.
Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Martin, You can have a look at the server load to know if it's busy. You will need to fix your network issues before inspecting any else I'd say. Regards, Jonathan 2016-10-03 21:02 GMT+02:00 Martin House <martin.house@gmail.com>:
Out of curiosity, does the amount of RAM make a significant difference? I've been trying to troubleshoot performance issues because of both network lag at our location. In trying to optimize the page-load speed during checkout, I've also upped the serve RAM to from 1gig to 4gigs. While that obviously doesn't address actual network lag (eg. bad pings or lost packets) it can at least help me verify if the issue is with my Koha server or with the building network. We are in a leased building, and have no control over the network infrastructure, so if I can rule out the server as a speed hindrance, then I can restart the conversation with IT.
Thanks,
Martin
Martin House martin.house@gmail.com www.martindhouse.com 704-996-0297 "An unexamined life is not worth living."
On Mon, Oct 3, 2016 at 2:50 PM, Chris Cormack <chrisc@catalyst.net.nz> wrote:
* rfblanchard (rfblanchard@hotmail.com) wrote:
I'm building a new koha server to replace our old koha 3.0.0 with koha 16.5.4. The new server has better specs than the old one. Towards the end of my work I started doing some basic testing of the screens compared to the old system. I noticed the new system is slower (much slower) than our old 3.0 koha. Basically any screen is 5x to 10x slower on the new version of koha. That includes anything from searching to loading the landing page of the opac. I checked on some of the koha demo sites and also noticed they are quite slow. Has koha just become bloated over time or have I misconfigured something?
I didn't build the original server, but I compared apache and mysql settings and didn't notice anything that the new install was missing. I tried using memcached but that did nothing useful as far as I noticed.
Does anyone have any insite into speeding up koha performance? caching? etc?
Koha now uses a database independent layer an ORM (Object relationship model). This allows (in theory) Koha to be run on different database engines, it also allows for more Object Oriented code, which a lot of people like.
It does have the downside of being quite a bit slower than straight SQL though, this accounts for most of the slow down you are noticing.
Did you install Koha via packages? If so, you will want to switch plack on
sudo koha-plack --enable <instancename> sudo koha-plack --start <instancename>
Then restart apache. You will want to set up memcache as well. To enable caching to occur. This should speed things up considerably.
Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Yea i used sudo apt-get install koha-common Thanks for that advice. I seen mentions of plack here and there but didn't know much about it. I enabled plack:
sudo koha-plack --enable <instancename> sudo koha-plack --start <instancename> and memcached: USE_MEMCACHED="yes" SetEnv MEMCACHED_SERVERS "127.0.0.1:11211" SetEnv MEMCACHED_NAMESPACE "koha_peischool"
That did make a performance difference in the speed of koha. -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Performance-Issue-tp5905752p5905918.h... Sent from the Koha-general mailing list archive at Nabble.com.
Hi, What are the specs of your server? Koha 3.0 and Koha 16.05 are completely different in term of features and architecture. I would recommend you to start a fresh install using packages (https://wiki.koha-community.org/wiki/Koha_on_Debian), re-inject your DB and upgrade it. Then you must enable plack and memcached to really enjoy Koha :) Don't hesitate to jump into our #koha irc channel! Regards, Jonathan 2016-10-03 20:42 GMT+02:00 rfblanchard <rfblanchard@hotmail.com>:
I'm building a new koha server to replace our old koha 3.0.0 with koha 16.5.4. The new server has better specs than the old one. Towards the end of my work I started doing some basic testing of the screens compared to the old system. I noticed the new system is slower (much slower) than our old 3.0 koha. Basically any screen is 5x to 10x slower on the new version of koha. That includes anything from searching to loading the landing page of the opac. I checked on some of the koha demo sites and also noticed they are quite slow. Has koha just become bloated over time or have I misconfigured something?
I didn't build the original server, but I compared apache and mysql settings and didn't notice anything that the new install was missing. I tried using memcached but that did nothing useful as far as I noticed.
Does anyone have any insite into speeding up koha performance? caching? etc?
-- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Performance-Issue-tp5905752.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Chris Cormack -
Jonathan Druart -
Martin House -
rfblanchard