If it starts swapping you have key_buffer set to high. -Eric
On Tue, 29 Jun 2004 15:41:20 -0500, Victor Pendleton <[EMAIL PROTECTED]> wrote: > > max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size > + sort_buffer_size) * max_connections > > > -----Original Message----- > From: Joćo Paulo Vasconcellos > To: Mysql-general Mailing List > Sent: 6/29/04 1:09 PM > Subject: Server tuning > > Hello everybody, > > I am setting up a server to do POP/SMTP authentication using > vpopmail. I took a look at the variables at global my.cnf and wondered > what would be the best values for things like key_buffer, > read_buffer_size and table_cache. I searched the manual, but it does > not go deep in this subject, or I was not capable of finding the right > place. What I want to know is how can I calculate how much memory I > should give to key_buffer before I start to give away too much memory. > That's because I got only 1GB of RAM and I have about 34k domains in > my database, averaging from 8 to 15 accounts each. In a normal > situation, there are ~400 simultaneous clients. I was wanting to know > how can I estimate the memory usage for this scenario, if exists some > kind of formula to answer this, like: > > clients * total size of key fields used in query > > or if this is some thing that is clear in the manual (if so, my > apologies, but I could not find). > > TIA, > -- > Joćo Paulo Vasconcellos > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
