On Tue, Mar 30, 2004 at 10:30:03AM -0800, Dathan Vance Pattishall wrote: > Tips on managing very large tables for myISAM: > > 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.
That's a common mis-conception: http://jeremy.zawodny.com/blog/archives/000796.html Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 198 days, processed 3,392,217,207 queries (197/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
