Re: DBMail/MySQL Config

xms@xxxxxx wrote:
> 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?

4.0.18 is fine.

> 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?

You wont have to recreate the database, unless its empty, then it won't 
matter.

You could issue

alter table xxx type=innodb

for each dbmail table, which is probably what your gui did. But from 
your my.cnf I can tell that you're most likely not running innodb 
tables, and my guess is either mysql failes silently ignoring the type= 
statement, or your gui is bogus and doesn't show errors.

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

If you run mysql-4.0.18 and it doesn't support innodb, you should 
consider using your trustix cd as a frisbee. But try setting up your 
my.cnf first:

just an example from my my.cnf:

innodb_data_file_path = ibdata1:10M:autoextend
innodb_data_home_dir = /var/lib/mysql/
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

but please read the docs.



--
  ________________________________________________________________
  Paul Stevens                                  mailto:paul@xxxxxx
  NET FACILITIES GROUP                     PGP: finger paul@xxxxxx
  The Netherlands________________________________http://www.nfg.nl