Good night everyone.
I have a question regarding tables in mysql.
Assuming the following scenario.
I have a MYSQL INNODB table with PK ID INT UNSIGNED. (4 billion records approx)
1 º If by chance I reach the registry 4,294,967,295.00 will not insert correct?
2nd If I partition this table in MYSQL type Partition Key in eg 200 partitions, the number of records is unlimited?
type I have 4.294.967.295,00 x 200 (partitions) in case I can get up to 858.993.459.000,00 records. Is this or anything to see?
I'm afraid to go beyond the INT UNSIGNED boundary, and I would not like to use BIG INT UNSIGNED or nvarchar.
Thank you!