Re: DBMail/MySQL Config

Hi,


I was not sure when i first installed DBMail if i could use innodb tables. I am 
running Mysql 4.0.18, any ideas?
I used a gui based mysql manager to change the type of one of my tables to 
innodb and it did not complain and appeared to work, do you think that means it 
will be OK to 
recreate my database using the DBMail innodb script?

If it turns out to support innodb, how should i set my my.cnf up?


Thanks in advance.
James

On Mon, 22 Mar 2004 14:29 , Paul J Stevens <paul@xxxxxx> sent:

>
>mysql:
>You aren't using innodb tables. Not Good (tm). You should.
>
>dbmail:
>
>NCHILDREN: You want to raise the NCHILDREN setting. Until my dynamic 
>preforking 
>patch is applied to CVS, NCHILDREN determines the absolute number of children 
>forked on startup, and thus, the number of simulaneous connections. Since 
>you're 
>running webmail only, that means one connection per client, but if you 
>accomodate clients like mozilla; they use up more than one connection.
>
>MAXCONNECTS: after MAXCONNECTS connections a forked child exits and restarts. 
>This will help prevent memory leaks get out of hand. There's very little 
>overhead in having child processes restart more often. 100 is probably a good 
>enough setting. But then, perhaps all those leaks were flushed out during the 
>2.0 cycle...
>
>
>xms@xxxxxx wrote:
>> Hi People,
>> 
>> Sorry for all the questions recently, but i am new to DBMail and wan't to 
>> make sure i have it set up perfectly.
>> I am going to be running with around 11,000 users on a P4 2.8ghz with 1.5gb 
>> Ram (Webmail via IMAP only).
>> It looks like i am going to be using dbmail-smtp for the moment, but may be 
>> moving to the lmtp in the future.
>> 
>> My main concerns are the way i have my my.cnf and my dbmail.conf file set-up:
>> 
>> 
>> MY.CNF:
>> 
>> [client]
>> port            = 3306
>> socket          = /var/run/mysql/mysql.sock
>> 
>> [mysqld]
>> port            = 3306
>> socket          = /var/run/mysql/mysql.sock
>> skip-locking
>> skip-networking
>> set-variable    = max_connections=500
>> set-variable    = key_buffer=256M
>> set-variable    = myisam_sort_buffer_size=64M
>> set-variable    = join_buffer=1M
>> set-variable    = record_buffer=2M
>> set-variable    = sort_buffer=2M
>> set-variable    = table_cache=256
>> set-variable    = thread_cache=8
>> set-variable    = wait_timeout=1800
>> set-variable    = connect_timeout=10
>> set-variable    = max_allowed_packet=32M
>> set-variable    = max_connect_errors=1000
>> server-id       = 1
>> 
>> [mysqldump]
>> quick
>> set-variable    = max_allowed_packet=16M
>> 
>> [mysql]
>> no-auto-rehash
>> 
>> [isamchk]
>> set-variable    = key_buffer=128M
>> set-variable    = sort_buffer=128M
>> set-variable    = read_buffer=2M
>> set-variable    = write_buffer=2M
>> 
>> [myisamchk]
>> set-variable    = key_buffer=128M
>> set-variable    = sort_buffer=128M
>> set-variable    = read_buffer=2M
>> set-variable    = write_buffer=2M
>> 
>> [mysqlhotcopy]
>> interactive-timeout
>> 
>> 
>> 
>> 
>> 
>> DBMAIL.CONF:
>> 
>> [DBMAIL]
>> host=localhost
>> sqlport=
>> sqlsocket=/var/run/mysql/mysql.sock
>> user=dbmail
>> pass=dbmail
>> db=dbmail
>> TRACE_LEVEL=1
>> 
>> [SMTP]
>> SENDMAIL=/usr/sbin/sendmail
>> DBMAIL_FROM_ADDRESS=bounce@xxxxxxxxxx
>> POSTMASTER=postmaster@xxxxxxxxxx
>> AUTO_NOTIFY=yes
>> AUTO_REPLY=yes
>> TRACE_LEVEL=1
>> 
>> [LMTP]
>> EFFECTIVE_USER=dbmail
>> EFFECTIVE_GROUP=dbmail
>> BINDIP=127.0.0.1
>> PORT=24
>> NCHILDREN=2
>> MAXCHILDREN=2
>> MAXCONNECTS=100
>> TIMEOUT=300
>> RESOLVE_IP=no
>> TRACE_LEVEL=1
>> MAX_ERRORS=500
>> 
>> [POP]
>> EFFECTIVE_USER=dbmail
>> EFFECTIVE_GROUP=dbmail
>> BINDIP=127.0.0.1
>> PORT=110
>> NCHILDREN=5
>> MAXCHILDREN=200
>> MAXCONNECTS=10000
>> TIMEOUT=300
>> RESOLVE_IP=no
>> POP_BEFORE_SMTP=no
>> TRACE_LEVEL=1
>> 
>> [IMAP]
>> EFFECTIVE_USER=dbmail
>> EFFECTIVE_GROUP=dbmail
>> BINDIP=127.0.0.1
>> PORT=143
>> NCHILDREN=5
>> MAXCONNECTS=10000
>> TIMEOUT=4000
>> RESOLVE_IP=yes
>> IMAP_BEFORE_SMTP=no
>> TRACE_LEVEL=1
>> 
>> 
>> 
>> Cheers
>> James
>> 
>> 
>> 
>> 
>> --- Msg sent via @Mail - http://atmail.nl/
>> _______________________________________________
>> Dbmail mailing list
>> Dbmail@xxxxxxxxxx
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>> 
>
>-- 
>   ________________________________________________________________
>   Paul Stevens                                         paul@xxxxxx
>   NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
>   The Netherlands_______________________________________www.nfg.nl
>



--- Msg sent via @Mail - http://atmail.nl/