Take the 2-minute tour ×
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. It's 100% free, no registration required.

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?

share|improve this question
1  
have a look at this: dba.stackexchange.com/questions/20335/… –  dezso Aug 29 '12 at 19:36
    
or try: duckduckgo.com/?q=mysql%20limitations –  Max Vernon Aug 29 '12 at 19:43
1  
Did you check the manual? 150k records is next to nothing... –  Frank Heikens Aug 29 '12 at 19:43
    
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. –  Max Vernon Sep 5 '12 at 14:15

2 Answers 2

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: 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.

share|improve this answer

Your Answer

 
discard

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.