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
ng on very well. :-)
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
>
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 kno
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.
Jerem
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. Otherwise, if MAX_ROWS is used, MySQL will assume
that each TEXT/BLOB column will be filled complet
