[Koha-devel] Stack smashing resolved -- we think
Chadwick, John, DCA
john.chadwick at state.nm.us
Tue Jan 12 00:03:14 CET 2010
Here is the link to the Wiki page that has some suggestions on MySQL
settings.
http://wiki.koha.org/doku.php?id=faq&s[]=memory&s[]=buffer
The information about memory is about half way down the page.
John
-----Original Message-----
From: Chris Cormack [mailto:chris at bigballofwax.co.nz]
Sent: Monday, January 11, 2010 12:59 PM
To: tajoli
Cc: Chadwick, John, DCA; koha-devel at lists.koha.org
Subject: Re: [Koha-devel] Stack smashing resolved -- we think
2010/1/12 tajoli <tajoli at cilea.it>:
> Hi,
>
>> Our server has 8GB of memory with a quad core processor. I allocated
>> 1000GB to the MyISAM sort buffer size. I also increased the key
buffer
>> size. I found a few things about memory, but not much, on the Koha
Wiki.
>> I would like to hear from others what you have found to be optimal
>> memory allocation for MySQL with about 20,000 bibs. Also, what would
the
>> optimal memory allocation for Zebra to use for indexing (or
reindexing).
>
> which version of Koha do you have ?
> Koha 3.x uses all tables on InnoDB, so it is strange that you increse
> MyISAM sort buffer size.
>
> How many check in/out do you do every day ?
> And during your peack hours ?
>
It also seems strange that changing mysql, would stop zebra segfaulting.
Chris
______________________________________________________________________
This inbound email has been scanned for malicious software and
transmitted safely to you using Webroot Email Security.
______________________________________________________________________
Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.
______________________________________________________________________
Confidentiality Notice: This e-mail,including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review,use,disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message.
This email has been scanned using Webroot Email Security.
______________________________________________________________________
More information about the Koha-devel
mailing list