On Monday 03 March 2003 16:03, Sigurd Urdahl wrote:
> In one of our customers databases there is table that have an
> extremely high max_data_length of about 256TB(!). Another have 1 TB,
> while the rest is at 4GB. (all of these tables are basically the same,
> but with these two as the ones witht
The default at table creation is 4GB. You can change the default vaule via
an ALTER TABLE. You will need to alter AVG_ROW_LENGTH and MAX_ROWS.
MAX_DATA_LENGTH is the product of the two.
http://www.mysql.com/doc/T/a/Table_size.html
Regards,
Bhavin.
- Original Message -
From: "Henry Hank" <
Eric Mayers <[EMAIL PROTECTED]> wrote:
> Okay, this is clearly not what I want. I'm looking for a method to see
> how much space a table is using compared to the total amount of space
> available. Is there a way to do this (with innodb tables)?
I haven't used InnoDB tables, but since no one el
L PROTECTED]]
> Sent: Monday, February 25, 2002 11:33 AM
> To: [EMAIL PROTECTED]
> Subject: Re: max_data_length?
>
>
> On 25 Feb 2002, at 10:03, Eric Mayers wrote:
>
> > Why is the max_data_length portion of "Show table status
> ..." for innodb
> > t
On 25 Feb 2002, at 10:03, Eric Mayers wrote:
> Why is the max_data_length portion of "Show table status ..." for innodb
> tables null? Is there a way to get this value? I want to use this and
> data_length to display a % of space used statistic.
I think you're misunderstanding what the max_dat