MySQL Database Size Limitation

Posted on 2011-04-22
Last Modified: 2012-05-11
What is the size limitation on MySQL databases?  Can they hold a terabyte of data like MS SQL Server?  I've seen a few web pages describing it, but I can't decipher it.
Question by:StumpedAndGrateful
    LVL 82

    Accepted Solution

    Here's the info from MySQL:  Note that they are talking about 'table' sizes, not database sizes.   Each table is in it's own file but a database can be many file in a directory.
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    just to clarify that this depends on the database engine you use, aka InnoDB, MyIsam etc ..
    while for MyIsam, the limitation is per table, for InnoDb, you create tablespaces with 1 or many files ...

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now