Hi Edward,
Thanks for the info, but I tried setting the avg_row_length
with no effect - I'm pretty sure you only need that for
dynamic format tables (with varchars and text). My table is
fixed format, and the table does claim to get around the
2/4GB limit.
My problem is the maximum number of r
Sorry, I meant to include this link, too.
http://www.mysql.com/doc/en/Table_size.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Martin Waite" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, 09 June, 2003 04:45
Subject: is i
Perhaps this has something to do with it:
"When you use a MyISAM table, MySQL uses the product of max_rows *
avg_row_length to decide how big the resulting table will be. If you don't
specify any of the above options, the maximum size for a table will be 4G (or 2G
if your operating systems only
