Dear all,

I have a question about the limitatin of table size.
If I use the InnoDB engine, I don't have to worry that the total size of
table is greater than the single filesize?

Thanks a lot!

Best,
Sookhyun.

At 10:47 PM -0400 3/18/08, Sookhyun Yang wrote:
>Dear all,
>
>I have a question about the limitatin of table size.
>If I use the InnoDB engine, I don't have to worry that the total size of
>table is greater than the single filesize?

You can create an InnoDB tablespace that spans multiple files, yes.
InnoDB will use the aggregate file size as the tablespace size.

But remember that multiple tables share the tablespace.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com