:-)) 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
Hi all,
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 withthe most data). The largest table
is currently
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 withthe
Hello,
While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem
to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any
dynamic tables are limited to 4GB in size? My fixed tables do not show this
problem, and report that their Max_data_length is 4
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 else
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.
Eric Mayers
Software Engineer I
Captus Networks
sql,query
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
: 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
tables null? Is there a way to get this value? I want to
use
, which brings me to
my question.. Why is max_data_length null? And is there a way I can
get to this value?
Is there a better/different way to do this?
Thanks,
Eric Mayers
Software Engineer I
Captus Networks
query.
-
Before
Shouldn't Max_data_length on a heap table be the same as the
max_heap_table_size variable as long is max_rows is not set? My heap table can
grow up to about 200mb. If I set the limit max_heap_table_size at 256MB,
Max_data_length ends up being around 110MB. This gives me the 'table is full'
error
11 matches
Mail list logo