Hi,
I can't find any mention of this in the MySQL manual. It discusses
the maximum file size, but what I want to know is if there
is some limitation (perhaps in the index file format) on
the number of rows a MyISAM or INNODB table can hold ?
regards,
Martin
--
MySQL General Mailing List
For l
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 num
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 n
Does anyone know what the maximum number of rows a
MyISAM table can store is? We currently have a table
(27 GB .MYD, 17GB .MYI) holding more than 2^31 rows:
mysql> select count(*) from BigTable;
++
| count(*) |
++
| 947945 |
++
1 row in set (0.09
the maximum number of rows that we can have
cn> in a table. In our case when the number of rows exceeds 1500
cn> the server crashes. Is it 1500 maximum number of rows that we
cn> can have ???
No.
What do you mean "server crashes"? It's going down or you get any
error me
Hi Mysql Gurus,
We are working a project using Mysql for the database support.
The environment is multiserver. We are using a single table for
all the servers to store server information. We basically want
to know what is the maximum number of rows that we can have
in a table. In our case when
---
> -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,
rows in the table
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
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
Hi MySql gurus,
We are using MySql for our database support in our project. It is
a multiserver environment. We are using a single table to store
info abt objects of each server. We want to know what is the
maximum number of rows that the MySql supports for a table.
In our case when the number
11 matches
Mail list logo