Shashank Tripathi wrote:
>
> Hi Lucas,
>
> | Does anyone know what the maximum number of rows a
> | MyISAM table can store is? We currently have a table
> | We're afraid there is hard, implementation imposed limit
> | of unsigned int (2^32) on the number of rows. Before trying
>
Hi Lucas,
| Does anyone know what the maximum number of rows a
| MyISAM table can store is? We currently have a table
| We're afraid there is hard, implementation imposed limit
| of unsigned int (2^32) on the number of rows. Before trying
My guess is that the limit is not in t
chandrashekar,
Tuesday, May 07, 2002, 12:19:54 PM, you wrote:
cn> We are working a project using Mysql for the database support.
cn> The environment is multiserver. We are using a single table for
cn> all the servers to store server information. We basically want
cn> to know what is the maximum n
---
> -Original Message-
> From: Paul [mailto:[EMAIL PROTECTED]]
> Sent: 07 May 2002 08:20
> To: Remco Oosten
> Cc: [EMAIL PROTECTED]
> Subject: Re: Maximum number of rows in the table
>
>
> Our MySQL table currently has 2.5million rows, but
> I don't think there is a limit.
> Just as long as your harddisk can contain the data there should be no
> problem.
Yes, I guess this should be the case.
Theoretically, though; the limit would be the number of indexable rows, wouldn't it?
Since the integer length used to store this is 11 digits,
Our MySQL table currently has 2.5million rows, but I have seen this go upto
at least 17 million rows without a single problem.
sql, query
- Original Message -
From: Remco Oosten
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 5:08 PM
Subject: Re: Maximum number of
I don't think there is a limit.
Just as long as your harddisk can contain the data there should be no
problem.
Remco
- Original Message -
From: "chandra shekar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 5:21 AM
Subject: Maximum number of rows in the table