On 30 Mar 2004 at 10:30, Dathan Vance Pattishall wrote: > 1) Ensure that the table type is not DYNAMIC but Fixed. > => Issue the show table status command. > => Look at Row Format > => if Row Format != Dynamic the your ok else get rid of varchar type > columns > => Reason: > Your myISAM table can grow only to 4GB then it will run out > of space even if your file system allows files to grow past 4GB.
There are reasons for using fixed-length rather than dynamic records, but that's not one of them. If you set MAX_ROWS high enough when creating your tables (or alter it later after they get big, though that could take a while), they'll be able to grow past 4 GB even if they're dynamic. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
