Re: [Koha-devel] for Nelsonville

[Joshua Ferraro]

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
> address@hidden
> https://lists.sourceforge.net/lists/listinfo/koha-devel