What is the maximum number of rows per table ?

2003-06-10 Thread Martin Waite
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

Re: Maximum number of rows

2002-09-02 Thread Lukas Knecht
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

RE: Maximum number of rows

2002-09-02 Thread Shashank Tripathi
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

Maximum number of rows

2002-09-02 Thread Lukas Knecht
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

Re: Maximum Number of rows in a table.

2002-05-07 Thread Egor Egorov
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

Maximum Number of rows in a table.

2002-05-07 Thread chandrashekar nagaraj
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

RE: Maximum number of rows in the table

2002-05-07 Thread Peter Lovatt
--- > -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

Re: Maximum number of rows in the table

2002-05-07 Thread webmaster
> 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,

Re: Maximum number of rows in the table

2002-05-07 Thread Paul
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

Re: Maximum number of rows in the table

2002-05-06 Thread Remco Oosten
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

Maximum number of rows in the table

2002-05-06 Thread chandra shekar
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