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 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?
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=arch...@jab.org
