calculating memory size

------=_NextPart_000_0043_01CB442E.DD61CE30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hello,

We are having issues with one of our servers sometimes hanging up and =
when attempting to shutdown the DB, we get "cannot create thread" =
errors.

This server has 6GB of RAM and no swap. According to some reasearch I =
was doing I found this formula for calculating memory size:
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
=3D (in your case) 384M + (64M + 2M)*1000 =3D 66384M That come directly =
from this old post: http://bugs.mysql.com/bug.php?id=3D5656In our case, =
the result is just below 6GB and then accounting for other apps, we =
would certainly exceed that. So, my question is simply: is that =
forumula accurate for determinning potential mysql memory allocation? =
Thanks!
------=_NextPart_000_0043_01CB442E.DD61CE30--

Re: calculating memory size

On 25/08/2010 8:23 a, Geoff Galitz wrote:
>
> Hello,
>
> We are having issues with one of our servers sometimes hanging up and when attempting to shutdown the DB, we get "cannot create thread" errors.
>
> This server has 6GB of RAM and no swap. According to some reasearch I was doing I found this formula for calculating memory size:
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = (in your case) 384M + (64M + 2M)*1000 = 66384M That come directly from this old post: http://bugs.mysql.com/bug.php?id=5656In our case, the result is just below 6GB and then accounting for other apps, we would certainly exceed that. So, my question is simply: is that forumula accurate for determinning potential mysql memory allocation? Thanks!
Are you running a 64bit OS/MySQL?
--
Jangita | +256 76 91 8383 | Y! & MSN: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org