On 4 Sep 2003 at 16:10, Keith Bussey wrote: > The MYI for that table is 1.7M, and no the text field isn't indexed > > Other table has all fixed-length records except 2 varchar fields.... > > Thus, if I understand right, then because the field is text it uses > more pointers than a larger table that has no text fields (in my case > atleast) ?
No, as I understand it, any MyISAM table with dynamic records should give the "table full" error when it reaches 4 GB, if it was created without specifying MAX_ROWS or AVG_ROW_LENGTH. If your other table doesn't have fixed-length records and was created without specifying either of those options, then I don't know how it got to 9 GB (unless maybe it doesn't have any indexes?). What does the output from SHOW TABLE STATUS and SHOW CREATE TABLE look like for it (not that that's likely to help with solving the problem for your other table)? -- 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]
