Data MySQL can support

Posted on 2011-10-05
Last Modified: 2012-05-12
Does MySQL support data upto 500,000 TB? If not, which database support upto that amount of data? Where can I find information about data support size of Database?
Question by:wangsasoft
    LVL 24

    Expert Comment

    500,000 TB???  I don't know the answer, but I'm curious why you need to know.  According to, the biggest so far 2.8 Petabytes, or "just" 2,800 TB.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    the question needs to be clarified on 500'000 TB for 1 single table? or for the hole db?

    in short: the size of the largest table is limited by the OS' filesystem, and not so much by the db engine you use.
    after that, you will have considerations on the primary keys etc ...

    so, if you create 1000'000 tables with 500 MB each, or 500'000 tables with 1 TB each (or some other variants), it would work with MySQL as well as any other db system, in general.

    however, I concur with above remark: 500'000 TB? for storing what?
    because that is also part of the question: is it text or binary? what would be the biggest size for a single "blob" part?

    Author Comment

    Thanks for your reply. Anyway, I got the project from Thai Government and the project specification indicated that I have to use the DBMS that can store up to 500,000 TB! I just want some proven to show to the project owner that MySQL can store up to 500,000 TB even it's not happen in the real life. Or if MySQL can't, can MS-SQL or Oracle can handle that or no!

    How do u think the way to prove to my customer regarding this?

    LVL 142

    Accepted Solution

    to prove this, you first would need to have the hardware for this, and the os installed for it.
    then, you need to have some specs on what the database needs to store, so that you can build a schema for it, and based on the schema, fill up those 500K TB on a real machine (with sample data) and see if this works.
    if then, you can still run queries etc, you have the proof.

    note: 500K TB of data means you need at least 2-3 times of the disk space, for indexes, backups etc ...

    Author Comment

    Thank angelIII for your advice. So what you mean MySQL can handle upto 500K TB, right? No limitation on its capacity. The limitation is hardware only.
    LVL 24

    Assisted Solution

    In theory MySQL should be able to handle it, but you will need to employ many techniques to make it reach that.  I don't see any way you can do this without using things like partitioning, sharding, clustering, etc.  You might want to have a MySQL support company such as Percona or, of course, Oracle's MySQL group, to back you up.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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

    Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    760 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

    10 Experts available now in Live!

    Get 1:1 Help Now