Skip navigation links

MySQL Forums :: MyISAM :: Maximum Number of Records in a table?


Advanced Search

Maximum Number of Records in a table?
Posted by: mylist ()
Date: September 01, 2005 05:58AM

I have a table that we are using this month for the first time. The table is a bit larger than pretty much all our other tables in use now.

We have the table set to archive off at the end of each month so no other records are written to it.

I noticed that our 08/31/05 archive had exactly 199,000 rows.

Did I hit some sort of limit or is it just by some strange coincidence that there are exactly this many records for the month?

We have a different number of records inserted each day.

I did look up the limits for tables but all I found was limits on the size of the data and numbers of columns etc., I could not find a limit on number of rows/records.

Any help is appreciated.

Wholesale Private Label Internet Access!
http://www.YourOwnISP.com

Options: ReplyQuote


Subject Views Written By Posted
Maximum Number of Records in a table? 76970 mylist 09/01/2005 05:58AM
Re: Maximum Number of Records in a table? 37982 Felix Geerinckx 09/01/2005 11:42AM
Re: Maximum Number of Records in a table? 17684 09/02/2005 03:42AM
Re: Maximum Number of Records in a table? 18894 danilo del giudice 10/02/2007 06:15AM
Re: Maximum Number of Records in a table? 13840 mylist 09/02/2005 09:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.