Date: Sun, 09 Jul 2006 17:53:38 -0400 From: Mike Jakubik <mikej@rogers.com> To: Mathieu Arnold <mat@FreeBSD.org> Cc: Darren Pilgrim <darren.pilgrim@bitfreak.org>, stable@freebsd.org Subject: Re: MySQL and default memory limits (mysqld: Out of memory) Message-ID: <44B17AE2.5020908@rogers.com> In-Reply-To: <2B636EF151DC536C47555034@[192.168.1.5]> References: <44B16BE9.60508@rogers.com> <E56FEA0F58A776685B3AB5DF@[192.168.1.5]> <44B171AA.9080400@bitfreak.org> <6C05189234026592B01C2703@[192.168.1.5]> <44B17437.5010506@bitfreak.org> <7215DBE558702ADFC8718798@[192.168.1.5]> <44B176F5.2050409@rogers.com> <2B636EF151DC536C47555034@[192.168.1.5]>
next in thread | previous in thread | raw e-mail | index | archive | help
Mathieu Arnold wrote: > | Exactly, its nice being able to see the current values. How else can i > | see what the values are set to? > > As I previously said, it's 512M on i386, and 1G on 64 bit platforms. > > Right, this explains why my amd64 system works just fine. Shouldn't this be a dynamic value based on total amount of ram? Say 70% of RAM, I mean servers have plenty of RAM nowadays, this seems like an old hard limit, which many new users will trip over.... I set my value to 805306368, and mysql seems to be happy now.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44B17AE2.5020908>