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]
