I blogged the file on my website some weeks back -- http://kados.org. I'm currently working on a Koha sys admin manual that will have an optimization section including an annotatated my.cnf to explain the options and how to tweak them based on the size of the database, the speed of the machine, and the functions performed ... I expect to complete the manual by the end of September (in time for my Koha presentation at OLC). For now, here are some parameters we are using on our machine (with a 1.4 gig database, and 2 gigs of RAM): key_buffer_size = 768M max_allowed_packet = 16M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M thread_concurrency = 2 # default is 32M ... but even with 128M about # 1/2 tmp_files are Created_tmp_disk_tables # can't go too high cause it's threaded tmp_table_size = 128M tmpdir = /tmp/ (we use tmpfs for /tmp) Joshua On Mon, Aug 16, 2004 at 03:49:16PM +0200, Paul POULAIN wrote:
Hi Nelsonville,
A few weeks ago, on IRC, you said that you have found a nice my.cnf to configure mySQL. You also said that you will publish it. What about this ?
-- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel