Re: Creating Innodb Database

[Scott Pippin]

>    In the MySQLdocumentation, it does not clearly explains how a Tablespace is
> created. Under "Creating a Tablespace" heading ( 14.4.4), it says how a Innodb database is
>  created but not >tablespace.  
>         Also how exactly you create an Innodb Database. Well it says in the
> documentation that   when you enter the cmd  "mysqld" it creates an Innodb Database, what
> if I want to have more >than one Innodb Database within a server. Do I have to run
> multiple instances of  "mysqld". Can someone help here?
 
Add the following to your config file - Note: this is for 4.0.x - not sure if 4.1.1 is
different.
 
# Uncomment the following if you are using Innobase tables
innodb_data_home_dir=/usr/local/mysql/libdata
innodb_data_file_path=libdata1:1000M;libdata2:1000M;libdata3:1000M
innodb_log_group_home_dir = /usr/local/mysql/innologs
innodb_log_arch_dir = /usr/local/mysql/innologs
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=5M
innodb_flush_log_at_trx_commit=2
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=200M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=120
 
This will create 3 files where the innodb tables will be put.  With 4.0.x and before you
can not assign tables to a particular file(tablespace).  You can do this with 4.1
however.  You can create as many databases as you need since it is the table that are
InnoDB and not the database itself.  I hope this helps.
 
Soctt Pippin
spippin@stripped