patternsqlMinor
Are there limitations on size or record count in MySQL?
Viewed 0 times
aresizelimitationsrecordmysqlcountthere
Problem
Are there any limitations to MySQL such as size or record limits?
The biggest tables in the database I am working on have over 150,000 rows. Will MySQL be able to handle that?
The biggest tables in the database I am working on have over 150,000 rows. Will MySQL be able to handle that?
Solution
Here are a couple resources from the docs on MySQL limitations.
Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables. [src]
There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. [src]
Every table (regardless of storage engine) has a maximum row size of 65,535 bytes. [src]
Bottom line is, MySQL can easily handle your scenario.
Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables. [src]
There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. [src]
Every table (regardless of storage engine) has a maximum row size of 65,535 bytes. [src]
Bottom line is, MySQL can easily handle your scenario.
Context
StackExchange Database Administrators Q#23383, answer score: 4
Revisions (0)
No revisions yet.