Time Nick Message 21:59 huginn eythian: The operation succeeded. 21:59 eythian @later tell wizzyrea https://blog.kallisti.net.nz/2016/04/the-jheronimus-bosch-exhibition/ 21:55 huginn eythian: The operation succeeded. 21:55 eythian @later tell cait https://blog.kallisti.net.nz/2016/04/the-jheronimus-bosch-exhibition/ 21:01 eythian then it's time to start exploring the "explain" command in mysql :) 21:01 geek_cl also i enable the slow query and yes, that querys appears 21:00 geek_cl definitly 21:00 geek_cl yes, just for check listing. i review many things.. trust me 21:00 eythian I think it's the fact that there are 600+ calls, and maybe something slow about the query. 21:00 eythian when I was working with Koha, we had the same setup. It shouldn't make that much difference. 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 20:56 geek_cl yes, i have memcached 20:56 geek_cl http://pastebin.com/jE2n7L2f 20:55 eythian also, do you have memcache installed? 20:55 eythian so I'd start looking in C4::Items::GetItemsInfo and see what it's doing. 20:55 eythian *shouldn't 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:54 geek_cl yes, the koha query took more than 4 secs 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:52 geek_cl searching rock at command line: http://snag.gy/9Vn9a.jpg 20:41 geek_cl ok, i will do that 20:41 eythian which will be faster 20:41 eythian if you run it without the parameter, it'll just give you the advanced search page (IIRC) 20:40 eythian I'd also prefix it with sudo -u koha-whatever 20:40 eythian putting 'q=rock' say as a command line parameter 20:40 geek_cl let me try 20:40 geek_cl so, the image is that profiles 20:39 eythian but, you can add search queries 20:39 eythian yeah, like that 20:39 eythian oh 20:39 geek_cl i run like this: perl -d:NYTProf /usr/share/koha/opac/cgi-bin/opac/opac-search.pl 20:39 eythian this makes running nytprof a lot more useful 20:39 geek_cl yeah? how ? 20:39 eythian so, a useful thing is that you can run searches on the command line 20:38 geek_cl 8 cores, 8 GB of RAM, 7 G free 20:38 geek_cl too much indeed 20:37 eythian (which is still too much, really.) 20:37 eythian maybe a bit more 20:37 eythian that looks more like about 4 seconds 20:37 eythian I'm not convinced that's a request that takes 20 seconds. 20:35 geek_cl eythian, so here the NYTProf _: http://snag.gy/SQbff.jpg 20:34 eythian nytprof will most likely give you the most useful hints 20:33 eythian strace is very hard to use on scripting languages 20:33 geek_cl and strace the opac-search.pl PID http://pastebin.com/QFM73PL6 20:32 geek_cl searching the letter "e", 28.8 secs 50082 results 20:31 geek_cl yes, i do that already 20:31 geek_cl eythian, always more than 10 secs 20:31 eythian if you want to get your hands dirty: https://wiki.koha-community.org/wiki/Profiling_with_Devel::NYTProf 20:29 geek_cl sometimes more 20:29 eythian that seems pretty extreme 20:29 geek_cl eythian, i receive 42 seconds at opac-search.pl , 20:29 geek_cl oh ok eythian thanks for confirm that 20:28 eythian It was on older debian versions 20:28 eythian right, I wouldn't meddle with that, it shouldn't be necessary. 20:27 geek_cl i am not installing, just confirming the content of /etc/perl/XML/SAX/ParserDetails.ini 20:27 eythian because it's the easy way generally :) 20:27 eythian is there a reason you're not doing a package install? 20:26 geek_cl and my content is: http://pastebin.com/hyVxzfrU 20:26 eythian doh 20:26 wahanui git is http://xkcd.com/1597/ 20:26 eythian wahanui: git 20:26 eythian that's not an official repository. 20:26 eythian last updated in 2012 20:25 geek_cl eythian, line 141 : https://github.com/dpavlin/Koha/blob/plack/INSTALL.debian 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:24 geek_cl Debian 8.2 jessie 20:24 eythian geek_cl: what OS and version? 20:23 geek_cl please please 20:23 geek_cl hi guys, anyone can confirm the content of : /etc/perl/XML/SAX/ParserDetails.ini