[Koha-devel] memcached - koha tuning

[Cindy Murdock Ames]

Hi all,

It looks like we've resolved our transaction speed problem--knock on 
wood!  Many, many, many thanks to everyone who provided suggestions for 
improvement.  Here's what Kyle and I did--I'm not sure what exactly 
helped, if it was one particular thing or a combo of many.

* Mysql config:  Increased innodb buffer pool size to 10000M (was 
1024M); followed mysqltuner recommendations to set join_buffer_size 
(32M), query_cache_limit (16M), query_cache_size (16M), tmp_table_size 
(8M) and max_heap_table_size (8m).  Mysqltuner still suggests more for 
those values, but the speed issue seems to be resolved so I'm not going 
to worry about it for now.  The max amount of system memory it can 
currently use is 85%.

* Moved the zebra db to another drive

* Optimized mysql tables; mysqltuner reported that one table was fragmented.

* Applied Mason's apache2 caching config recommendations

* Storing session files on a ramdisk (/dev/shm) (Dobrica's suggestion)

* mod_perl --Kyle got it to work by adding the following to httpd.conf:
       
        <Files *.pl>
        SetHandler perl-script
        PerlResponseHandler ModPerl::PerlRunPrefork
        PerlOptions +ParseHeaders
        PerlSendHeader On
        Options +ExecCGI
        </Files>

        PerlWarn On
        PerlRequire /home/koha/startup.pl

Cheers!
Cindy


Cindy Murdock Ames wrote:
> Thanks everyone for the pointers on tuning Koha.  I'm working on 
> implementing many of them right now.  I'll let you know how things 
> work out.  I'm thinking this would be a good topic for the wiki.  ;)
>
> Cheers!
> Cindy
>


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Cindy Murdock Ames
IT Services Director
Meadville Public Library    | CCFLS
http://meadvillelibrary.org | http://ccfls.org