On Tue, Dec 23, 2003 at 07:07:57PM -0600, Matt W wrote:
Hi Jeremy,
- Original Message -
From: Jeremy Zawodny
Sent: Monday, December 22, 2003 2:20 PM
Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH
On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote:
Hi Mark
Hi Jeremy,
- Original Message -
From: Jeremy Zawodny
Sent: Monday, December 22, 2003 2:20 PM
Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH
On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote:
Hi Mark,
I'll tell you what I know. :-)
First, AVG_ROW_LENGTH is only
. :-)
More below...
- Original Message -
From: Mark Hawkes
Sent: Saturday, December 20, 2003 3:50 PM
Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH
Hi Matt,
Thanks very much for your thoughts and advice. I was going to ignore
using
MAX_ROWS, MIN_ROWS and AVG_ROW_LENGTH because
On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote:
Hi Mark,
I'll tell you what I know. :-)
First, AVG_ROW_LENGTH is only needed for dynamic row-length tables (it's
ignored with fixed-length rows) -- more specifically, those with
TEXT/BLOB columns.
And VARCHAR/VARBINARY.
Jeremy
--
Hi all,
At table creation time I can use MAX_ROWS and AVG_ROW_LENGTH to
(a) limit the size of a HEAP table
(b) overcome MyISAM's default 4GB limit
But are they used in any other ways? Does MySQL use them to improve
performance by sizing buffers appropriately or to prevent fragmentation in
2 years old!
- Original Message -
From: Mark Hawkes
Sent: Friday, December 19, 2003 10:01 AM
Subject: Benefits of MAX_ROWS and AVG_ROW_LENGTH
Hi all,
At table creation time I can use MAX_ROWS and AVG_ROW_LENGTH to
(a) limit the size of a HEAP table
(b) overcome MyISAM's