Re: calculating memory size (again)

2010-08-25 Thread Baron Schwartz
Hi Geoff, > 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 fro

calculating memory size (again)

2010-08-24 Thread Geoff Galitz
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