[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
