Thanks Dobrica. I've seen your post before when looking for a solution to those innodb problems. I'll give mysqltuner a shot this weekend while we're closed, as well as the session files. Cheers, c. Dobrica Pavlinusic wrote:
http://blog.rot13.org/2010/04/mysql_is_slow_did_you_tune_your_settings.html
Just running mysqltuner.pl or tuning-primer.sh will probably be enough :-)
I would highly recommend putting session files at filesystem as opposed to database, especially if you have semi-high load on your website (web crawlers and what not) because it cut down database load by 75% for us.
Testing current memcache in Koha, it seemed to be used only for localization caching, and it was a bit slower on our system after some basic profiling. YMMV.
I documented my journy over mysql tuning for Koha at:
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS http://meadvillelibrary.org | http://ccfls.org