← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:47 | Francesca joined #koha | |
| 02:46 | mtompset_ joined #koha | |
| 04:57 | matts_away joined #koha | |
| 04:58 | NateC joined #koha | |
| 05:01 | Francesca joined #koha | |
| 05:06 | reyloi joined #koha | |
| 05:16 | Francesca joined #koha | |
| 05:47 | cdickinson joined #koha | |
| 06:14 | Francesca joined #koha | |
| 06:30 | cait joined #koha | |
| 07:39 | Francesca joined #koha | |
| 07:49 | cait joined #koha | |
| 08:25 | rocio left #koha | |
| 08:42 | SamEEE joined #koha | |
| 08:55 | cait joined #koha | |
| 09:06 | Francesca joined #koha | |
| 09:14 | sophie_m joined #koha | |
| 10:17 | cait joined #koha | |
| 10:19 | drab joined #koha | |
| 10:48 | SamEEE joined #koha | |
| 11:03 | cait joined #koha | |
| 12:56 | JoshB joined #koha | |
| 13:16 | edveal joined #koha | |
| 15:32 | NateC joined #koha | |
| 16:20 | cait joined #koha | |
| 17:33 | rocio joined #koha | |
| 19:29 | NateC joined #koha | |
| 19:39 | NateC joined #koha | |
| 19:44 | edveal joined #koha | |
| 20:23 | geek_cl | hi guys, anyone can confirm the content of : /etc/perl/XML/SAX/ParserDetails.ini |
| 20:23 | please please | |
| 20:24 | eythian | geek_cl: what OS and version? |
| 20:24 | geek_cl | Debian 8.2 jessie |
| 20:24 | eythian | you oughtn't need to touch that file I think. I don't have a koha install handy to check, but what the OS installs for you should be OK |
| 20:25 | cait joined #koha | |
| 20:25 | geek_cl | eythian, line 141 : https://github.com/dpavlin/Koh[…]ck/INSTALL.debian |
| 20:26 | eythian | last updated in 2012 |
| 20:26 | that's not an official repository. | |
| 20:26 | wahanui: git | |
| 20:26 | wahanui | git is http://xkcd.com/1597/ |
| 20:26 | eythian | doh |
| 20:26 | geek_cl | and my content is: http://pastebin.com/hyVxzfrU |
| 20:27 | eythian | is there a reason you're not doing a package install? |
| 20:27 | because it's the easy way generally :) | |
| 20:27 | geek_cl | i am not installing, just confirming the content of /etc/perl/XML/SAX/ParserDetails.ini |
| 20:28 | eythian | right, I wouldn't meddle with that, it shouldn't be necessary. |
| 20:28 | It was on older debian versions | |
| 20:29 | geek_cl | oh ok eythian thanks for confirm that |
| 20:29 | eythian, i receive 42 seconds at opac-search.pl , | |
| 20:29 | eythian | that seems pretty extreme |
| 20:29 | geek_cl | sometimes more |
| 20:31 | eythian | if you want to get your hands dirty: https://wiki.koha-community.or[…]th_Devel::NYTProf |
| 20:31 | geek_cl | eythian, always more than 10 secs |
| 20:31 | yes, i do that already | |
| 20:32 | searching the letter "e", 28.8 secs 50082 results | |
| 20:32 | cdickinson joined #koha | |
| 20:33 | geek_cl | and strace the opac-search.pl PID http://pastebin.com/QFM73PL6 |
| 20:33 | eythian | strace is very hard to use on scripting languages |
| 20:34 | nytprof will most likely give you the most useful hints | |
| 20:35 | geek_cl | eythian, so here the NYTProf _: http://snag.gy/SQbff.jpg |
| 20:37 | eythian | I'm not convinced that's a request that takes 20 seconds. |
| 20:37 | that looks more like about 4 seconds | |
| 20:37 | maybe a bit more | |
| 20:37 | (which is still too much, really.) | |
| 20:38 | geek_cl | too much indeed |
| 20:38 | 8 cores, 8 GB of RAM, 7 G free | |
| 20:39 | eythian | so, a useful thing is that you can run searches on the command line |
| 20:39 | geek_cl | yeah? how ? |
| 20:39 | eythian | this makes running nytprof a lot more useful |
| 20:39 | geek_cl | i run like this: perl -d:NYTProf /usr/share/koha/opac/cgi-bin/opac/opac-search.pl |
| 20:39 | eythian | oh |
| 20:39 | yeah, like that | |
| 20:39 | but, you can add search queries | |
| 20:40 | geek_cl | so, the image is that profiles |
| 20:40 | let me try | |
| 20:40 | eythian | putting 'q=rock' say as a command line parameter |
| 20:40 | I'd also prefix it with sudo -u koha-whatever | |
| 20:41 | if you run it without the parameter, it'll just give you the advanced search page (IIRC) | |
| 20:41 | which will be faster | |
| 20:41 | geek_cl | ok, i will do that |
| 20:52 | searching rock at command line: http://snag.gy/9Vn9a.jpg | |
| 20:54 | eythian | OK, so most of that is running an SQL query. I'd start by seeing if you can figure out why that is slow. |
| 20:54 | geek_cl | yes, the koha query took more than 4 secs |
| 20:54 | eythian | (also, it probably should be doing it that many times, but in the short term check to see if whatever table it's searching has all the right indexes set up.) |
| 20:55 | *shouldn't | |
| 20:55 | so I'd start looking in C4::Items::GetItemsInfo and see what it's doing. | |
| 20:55 | also, do you have memcache installed? | |
| 20:56 | geek_cl | http://pastebin.com/jE2n7L2f |
| 20:56 | yes, i have memcached | |
| 20:59 | eythian, in terms of apache <=> mysql, the mysql is a remote servers, connected to the koha server by a exclusive network interface | |
| 21:00 | eythian | when I was working with Koha, we had the same setup. It shouldn't make that much difference. |
| 21:00 | I think it's the fact that there are 600+ calls, and maybe something slow about the query. | |
| 21:00 | geek_cl | yes, just for check listing. i review many things.. trust me |
| 21:00 | definitly | |
| 21:01 | also i enable the slow query and yes, that querys appears | |
| 21:01 | eythian | then it's time to start exploring the "explain" command in mysql :) |
| 21:55 | Francesca joined #koha | |
| 21:55 | eythian | @later tell cait https://blog.kallisti.net.nz/2[…]bosch-exhibition/ |
| 21:55 | huginn | eythian: The operation succeeded. |
| 21:58 | irma joined #koha | |
| 21:59 | eythian | @later tell wizzyrea https://blog.kallisti.net.nz/2[…]bosch-exhibition/ |
| 21:59 | huginn | eythian: The operation succeeded. |
| 22:04 | Francesca joined #koha | |
| 22:08 | Francesca joined #koha | |
| 22:15 | mario joined #koha | |
| 23:01 | Francesca joined #koha | |
| 23:34 | JoshB joined #koha |
← Previous day | Today | Next day → | Search | Index