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]
