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 <[EMAIL PROTECTED]> 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... > > >[EMAIL PROTECTED] 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 >> [EMAIL PROTECTED] >> [EMAIL PROTECTED] >> 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 >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > >-- > ________________________________________________________________ > Paul Stevens [EMAIL PROTECTED] > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands_______________________________________www.nfg.nl > --- Msg sent via @Mail - http://atmail.nl/
