Yes there is, that's what Paul was referring to regarding InnoDB...it has a table space made up of multiple files on the disk and the tables reside within the tablespace. Thus the tables are not bound by the file system's maximum file size.
Details are in the MySQL manual in the table types section: http://www.mysql.com/doc/en/InnoDB.html or at InnoDB.com: http://www.innodb.com/ --Ware Titu Kim wrote: >Hi, > Thanks for the fast response. I wonder there is a >'tablespace' notion in mysql just like the one in >Oracle. One can keep adding datafile from different >disk to the same tablespace and don't have to worry >about how the data is stored in the files. > > >Thanks again. >--- Paul DuBois <[EMAIL PROTECTED]> wrote: >> At 18:05 -0500 6/6/03, Paul DuBois wrote: >> >At 15:59 -0700 6/6/03, Titu Kim wrote: >> >>2. How can i add another file to a table if the >> .MYD >> >>file grows too large? >> > >> >Once the file size reaches its maximum, that's as >> far as you can go. >> >> I should add to this that one way to obtain an >> effective larger >> "file" size is to use the RAID options at CREATE >> TABLE size. >> Requires that RAID support is compiled into your >> server, though. >> >> Or perhaps you could use an InnoDB table, which >> allows very large >> table sizes that are not limited by the size of a >> single file. >> >> -- >> Paul DuBois, Senior Technical Writer >> Madison, Wisconsin, USA >> MySQL AB, www.mysql.com >> >> Are you MySQL certified? >> http://www.mysql.com/certification/ >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> > > >__________________________________ >Do you Yahoo!? >Yahoo! Calendar - Free online calendar with sync to Outlook(TM). >http://calendar.yahoo.com > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
