How many rows can msql handle

Posted on 2012-08-13
Last Modified: 2012-08-13
how many rows can a mysql table hold
Question by:mugsinc
    LVL 25

    Expert Comment

    LVL 3

    Expert Comment

    There isn't a row limit, but a size limit. Please refer to
    LVL 13

    Accepted Solution

    The table size limit is based on the operating system drive file system that MySQL is installed on, ranging from 2GB to 2TB. So nobody can say exactly how many rows a table can hold. But don't worry, they hold a lot of tables.

    See the MySQL reference manual for full explanations of limits for each operating system.
    LVL 82

    Expert Comment

    by:Dave Baldwin
    That is normally limited by the file system of the OS that it is running on.  My default install of MySQL on Windows allows a data pointer size for 256TeraBytes which is way larger than Windows XP will ever handle.  A single table file could be 2 TeraBytes on Win32 w/NTFS.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API ( …
    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    734 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

    21 Experts available now in Live!

    Get 1:1 Help Now