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