Victor,
Thanks for all your help with the authentication issue. I still have it, but at least
I know what to look for.
My server is running RH9 with 3 gigs ram, PIII. I have about 150 users at any given
time and they're all coming via IMAP or HTTPD. They all authenticate against MySQL
but the mail is not stored there, it's in virtual domain files.
My /etc/my.cnf
Set-variabe = max_connections=1000
Key_buffer_size=512M
Sort_buffer=20M
Join_buffer=1M
Record_buffer=1M
Max_allowed_packet=2M
Table_cache=1024
Innodb_buffer_pool_size=256M
Are these variables ok? Reading my MySql manual, these were the best I could come up
with.
Thanks!
-----Original Message-----
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 4:41 PM
To: 'Jo�o Paulo Vasconcellos '; 'Mysql-general Mailing List '
Subject: RE: Server tuning
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]
