.0/en/create-table.html
Thanks
ViSolve DB Team.
- Original Message -
From: "Amit Dor-Shifer" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 28, 2006 7:54 PM
Subject: How to calculate max number of rows in a MyISAM table (default
MAX_ROWS) ?
> Hi.
> I've c
Hi.
I've created the following table, with default value for MAX_ROWS. As
the following shows, it has a max. size of 4G.
I'm wondering: Is the expected max number of rows in this table =
Max_data_length \ Avg_row_length?
If not, what might it be?
How do I calculate it?
mysql> show
Hi.
On Wed 2002-06-05 at 14:21:03 -0500, [EMAIL PROTECTED] wrote:
> In the last episode (Jun 05), Pooja Daryani said:
>
> > > I need to know how many rows are supported in mysql db.
>
> If there is a limit, it's probably 4294967296 rows. But you'll
> never get that many in a table anyway.
:-)
In the last episode (Jun 05), Pooja Daryani said:
>
>
> > Hi All,
> >
> > I need to know how many rows are supported in mysql db.
If there is a limit, it's probably 4294967296 rows. But you'll never
get that many in a table anyway.
--
Dan Nelson
[EMAIL PROTECTED]
--
> Hi All,
>
> I need to know how many rows are supported in mysql db.
>
> Thanks,
> Pooja.
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
