| Time |
S |
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:05 |
|
|
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 |
|
geek_cl |
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 |
|
eythian |
that's not an official repository. |
| 20:26 |
|
eythian |
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 |
|
eythian |
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 |
|
eythian |
It was on older debian versions |
| 20:29 |
|
geek_cl |
oh ok eythian thanks for confirm that |
| 20:29 |
|
geek_cl |
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 |
|
geek_cl |
yes, i do that already |
| 20:32 |
|
geek_cl |
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 |
|
eythian |
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 |
|
eythian |
that looks more like about 4 seconds |
| 20:37 |
|
eythian |
maybe a bit more |
| 20:37 |
|
eythian |
(which is still too much, really.) |
| 20:38 |
|
geek_cl |
too much indeed |
| 20:38 |
|
geek_cl |
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 |
|
eythian |
yeah, like that |
| 20:39 |
|
eythian |
but, you can add search queries |
| 20:40 |
|
geek_cl |
so, the image is that profiles |
| 20:40 |
|
geek_cl |
let me try |
| 20:40 |
|
eythian |
putting 'q=rock' say as a command line parameter |
| 20:40 |
|
eythian |
I'd also prefix it with sudo -u koha-whatever |
| 20:41 |
|
eythian |
if you run it without the parameter, it'll just give you the advanced search page (IIRC) |
| 20:41 |
|
eythian |
which will be faster |
| 20:41 |
|
geek_cl |
ok, i will do that |
| 20:52 |
|
geek_cl |
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 |
|
eythian |
*shouldn't |
| 20:55 |
|
eythian |
so I'd start looking in C4::Items::GetItemsInfo and see what it's doing. |
| 20:55 |
|
eythian |
also, do you have memcache installed? |
| 20:56 |
|
geek_cl |
http://pastebin.com/jE2n7L2f |
| 20:56 |
|
geek_cl |
yes, i have memcached |
| 20:59 |
|
geek_cl |
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 |
|
eythian |
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 |
|
geek_cl |
definitly |
| 21:01 |
|
geek_cl |
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 |
