RE: Maximum number of rows in the table
Jeremy at yahoo quoted one with 280 million rows, I think. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -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 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 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 > Subject: Maximum number of rows in the table > > > > 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 of rows exceeds 1500 the server > > crashes. Is it the max number of rows ? > > > > with regards, > > Chandrashekar B.N. > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Maximum number of 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. 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, this would amount to 10^11 = 100 000 000 000... Although probably not practially achievable; at least its quite far from 1500... Best regards, Eivind :-) mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Maximum number of rows in the table
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 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 Subject: Maximum number of rows in the table > 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 of rows exceeds 1500 the server > crashes. Is it the max number of rows ? > > with regards, > Chandrashekar B.N. > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Maximum number of 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 Subject: Maximum number of rows in the table > 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 of rows exceeds 1500 the server > crashes. Is it the max number of rows ? > > with regards, > Chandrashekar B.N. > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Maximum number of rows in the table
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 of rows exceeds 1500 the server crashes. Is it the max number of rows ? with regards, Chandrashekar B.N. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php