Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
have a look at this:… – dezso Aug 29 '12 at 19:36
Did you check the manual? 150k records is next to nothing... – Frank Heikens Aug 29 '12 at 19:43

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.

share|improve this answer
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

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

Many of the 'hard' limits are here:,25724,224521 (and a subsequent post)

Some 'practical' limits are posted here:

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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