calculating memory size (again)

Re-sending... my mail client or server somehow mangled my original
message... sorry.


------------------------------------------------------------ ------------------

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=5656

In 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!




--
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

Re: calculating memory size (again)

Hi Geoff,

> This server has 6GB of RAM and no swap. =A0According 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=
=3D5656
>
> In our case, the result is just below 6GB and then accounting for other
> apps, we would certainly exceed that. =A0So, my question is simply: is th=
at
> forumula accurate for determinning potential mysql memory allocation?

No, it is not at all. It never was, and many people have had trouble
with it just as you have. There really is no way to do what that
formula tries to do.

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