Hi Dan, (Sending to the General list too, since this isn't a Windows-specific thing.)
SHOW TABLE STATUS LIKE 'tbl_name' will show you the current Avg_row_length. But the specific values for MAX_ROWS and AVG_ROW_LENGTH when you CREATE or ALTER the table don't matter (except for "looking correct" :-)) as long as their product is greater than 4GB. BTW, you can't have the limit be 8GB -- when you go greater than 4GB, the Max_data_length will be 1TB. Hope that helps. Matt ----- Original Message ----- From: "Dan" Sent: Tuesday, April 13, 2004 3:58 PM Subject: Altering MAX_DATA_LENGTH > If I have a table that has two fields: Char(100), Blob > > How do I determine the avg_row_length value if I want to increase the size limit to 8GB? > > Thanks > Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
