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
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel