Tags
There are no tags for this page.
Incoming Links
There are no pages that link to this page yet.
Attachments
KOHA
Koha performance
Ova stranica dokumentira naša podešavanja (i pokušaje) za što bržom Koha instalacijom.
Apache deflate kompresija
Smanjuje veličinu stranice koja se isporučije browersu.
Session
dpavlin@koha:~$ sudo ./mk-query-digest /var/log/mysql/mysql-slow.log
# Profile
# Rank Query ID Response time Calls R/Call Item
# ==== ================== ================ ===== ======== ================
# 1 0xC7A803CDD4FE9A36 30517.0000 45.5% 349 87.4413 INSERT UPDATE sessions
# 2 0xB4F2B316DFE865C8 8027.0000 12.0% 119 67.4538 SELECT sessions
# 3 0x6019E0D94A244FF5 3952.0000 5.9% 275 14.3709 SELECT opac_news
# 4 0x1F809CA9753CDEE7 2753.0000 4.1% 23 119.6957 SELECT biblio
# 5 0x27CE7D5D2BC5F598 2305.0000 3.4% 206 11.1893 SELECT fieldmapping
# 6 0xB0F504DD073A49CB 2192.0000 3.3% 30 73.0667 SELECT issues items biblio biblioitems
# 7 0x8ED635CB153D27A5 2146.0000 3.2% 19313 0.1111 SELECT reserves reserveconstraints
# 8 0xDB6DC1962741AB10 1978.0000 3.0% 7 282.5714 SELECT biblio biblioitems itemtypes
# 9 0x32783383AEA5AD49 1642.0000 2.4% 10 164.2000 SELECT items
# 10 0x6DD9F09DA2455228 1361.0000 2.0% 8 170.1250 DELETE sessions
Promjeniti SessionStorage u "as temporary files" i opcionalno pomaknuti ih u /dev/shm umjesti o u /tmp/:
dpavlin@koha:~$ diff -urw /srv/koha/C4/Auth.pm /usr/share/koha/lib/C4/Auth.pm
--- /srv/koha/C4/Auth.pm 2010-02-20 21:41:34.000000000 +0100
+++ /usr/share/koha/lib/C4/Auth.pm 2010-04-26 16:03:17.671211497 +0200
@@ -1341,7 +1341,7 @@
}
else {
# catch all defaults to tmp should work on all systems
- $session = new CGI::Session("driver:File;serializer:yaml;id:md5", $sessionID, {Directory=>'/tmp'});
+ $session = new CGI::Session("driver:File;serializer:yaml;id:md5", $sessionID, {Directory=>
Profile
Devel::NYTProf
instalacija:
root@koha-dev-git-reorg:~# cpan Devel::NYTProf
profile search query:
root@koha-dev-git-reorg:/usr/share/koha/opac/cgi-bin/opac# time perl -d:NYTProf -I/usr/share/koha/lib/ opac-search.pl q=human | wc
1553 3259 58648
real 0m4.001s
user 0m3.152s
sys 0m0.560s
generate html report:
root@koha-dev-git-reorg:/usr/share/koha/opac/cgi-bin/opac# nytprofhtml
Generating report...
Reading nytprof.out
Writing report to nytprof directory
koha-240
First run
dpavlin@koha-240:/tmp$ time perl -d:NYTProf -I/usr/share/koha/lib/ /usr/share/koha/opac/cgi-bin/opac/opac-search.pl q=human | wc
Use of uninitialized value $borrowernumber in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 483.
Use of uninitialized value in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 486.
1962 3177 64512
real 0m8.561s
user 0m5.708s
sys 0m0.724s
Second run
dpavlin@koha-240:/tmp$ time perl -d:NYTProf -I/usr/share/koha/lib/ /usr/share/koha/opac/cgi-bin/opac/opac-search.pl q=human | wc
Use of uninitialized value $borrowernumber in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 483.
Use of uninitialized value in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 486.
1962 3177 64512
real 0m6.664s
user 0m5.636s
sys 0m0.816s
Drop caches and run profile:
dpavlin@koha-240:/tmp$ sudo sh -c 'echo 3 > /proc/sys/vm/drop_caches'
Zebra reindex
dpavlin@koha-240:/srv/koha$ sudo -u koha ./misc/migration_tools/rebuild_zebra.pl -b -v -r -d /tmp/indexing -k -x -nosanitize
|