Elena,
<yiyun@basenet.co.jp> kirjoitti
viestissä:1106190515.780825.292570@z14g2000cwz.goo glegroups.com...[color=blue]
> Hi,
>
> I am new to mysql and I want to ask a simple questions.
>
> I would like to initialize my InnoDB table space and I configure like
> below:
>
> innodb_data_file_path=ibdata1:1024M;ibdata2:64M:au toextend:max:1024M
>
> My questions are:
>
> 1. Is max used with autoextend?[/color]
yes.
[color=blue]
> So that I cannot configure like below:
>
> innodb_data_file_path=ibdata1:64M:max:1024M;ibdata 2:64M:autoextend:max:1024M[/color]
That would be a syntax error.
[color=blue]
> 2. I initizlize ibdata1 to 1024M; does this mean that when I add data,
> they firstly go into ibdata1 and when ibdata1 is full, they are added
> to ibdata2?[/color]
Yes.
[color=blue]
> 3. What happens when ibdata2 reaches 1024M?
> Thank you in advance for your time![/color]
You will start getting 'Table is full' errors, as ibdata2 cannot extend
further.
[color=blue]
> Sincerely,
>
> Elena[/color]
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php 
