MySQL Forums
Forum List  »  MyISAM

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!

Options: ReplyQuote

Written By
Maximum Number of Records in a table?
September 01, 2005 05:58AM
September 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.