Quoting "Keith C. Ivey" <[EMAIL PROTECTED]>: > On 4 Sep 2003 at 15:31, Keith Bussey wrote: > > > I do have another Database on the same machine which has a table that > > is a lot bigger (about 9 GIGs) and it wasn't created with any of the > > special table options suggested by Keith C. Ivey below. > > Does the other table have fixed-length records (no VARCHAR, TEXT, or > BLOB columns)? If so, the numbers for the pointers are in records, > not bytes, so the table can reach 2**32 - 1 records before it's full. > You can see what the maximum data length is with SHOW TABLE STATUS. > > For teh email_boy table, do you have any index other than the one for > the primary key? The .MYI file isn't getting big, is it?
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) ? > -- > 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]
