5

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?

2
4

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.

2
  • 1
    The rowsize max is confusing -- BLOBs and TEXTs do not count toward the 64KB limit. – Rick James Aug 29 '12 at 21:29
  • BLOBs and TEXT do count somewhat towards the limit, but you're right, it's not as simple as saying 64KB row size – Derek Downey Aug 29 '12 at 21:47
2

A million rows -- not a problem. A billion rows -- that gets interesting.

Many of the 'hard' limits are here: http://forums.mysql.com/read.php?21,25724,224521 (and a subsequent post)

Some 'practical' limits are posted here: http://mysql.rjweb.org/doc.php/ricksrots

A column can be 4GB (LONGTEXT or LONGBLOB), but there are other limits that may prevent you from actually creating that fat a record.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.