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

Re: calculating memory size

2010-08-25 Thread Jangita
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 acco

calculating memory size (again)

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

calculating memory size

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