Are there limitations on size or record count in MySQL?

Question

I am building an application which uses MySQL as the database.

I would like to find out if there are any limitations to MySQL like size or record limit?

The biggest tables in the database I am working on have over 150,000 records. Will it be able to handle it?

have a look at this: dba.stackexchange.com/questions/20335/…
Did you check the manual? 150k records is next to nothing...
I down-voted this since the question shows no signs of any level of research effort prior to asking the question. The MySQL website contains the answers to the question.

Derek Downey · Answer 1 · 2012-08-29 20:21:51Z

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.

The rowsize max is confusing -- BLOBs and TEXTs do not count toward the 64KB limit.
BLOBs and TEXT do count somewhat towards the limit, but you're right, it's not as simple as saying 64KB row size

Rick James · Answer 2 · 2012-08-29 21:34:17Z

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.

2 Answers