dcsimg
Results 1 to 6 of 6

Thread: I need insert info on MySQL database.

  1. #1

    Thread Starter
    Addicted Member tgf-47's Avatar
    Join Date
    Feb 2010
    Location
    CapeTown, South Africa -34.01244,18.337415
    Posts
    209

    Question I need insert info on MySQL database.

    Can anybody tell me what is the row-limit of a MySQL table?

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,674

    Re: I need insert info on MySQL database.

    You mean like the maximum number of rows you can insert into a table?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3

    Thread Starter
    Addicted Member tgf-47's Avatar
    Join Date
    Feb 2010
    Location
    CapeTown, South Africa -34.01244,18.337415
    Posts
    209

    Re: I need insert info on MySQL database.

    Yes, the the maximum number of rows that can be inserted into a MySQL table

  4. #4
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: I need insert info on MySQL database.


  5. #5

    Thread Starter
    Addicted Member tgf-47's Avatar
    Join Date
    Feb 2010
    Location
    CapeTown, South Africa -34.01244,18.337415
    Posts
    209

    Re: I need insert info on MySQL database.

    I saw the summary table there. I'm using the InnoDB option. It only says that it has a 64TB capacity.
    So does that mean that there is no limit to one table, only to the size of the whole database?

  6. #6
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: I need insert info on MySQL database.

    Storage capacity depends on how data is physically stored (addressing), specifically segment.page.row addresses in tablespaces.

    Segment is used to identify database object, e.g. table, index. So we are more concerned with page.row components of address. Since each page (which contains rows) is 16KB in size, and you can reference up to typical 4GB limit of memory addresses in 32 bit systems then you have 16KB * 4GB = 64TB limit for a database object that uses InnoDB. If you have two tables in the database then your database can be as large as 128TB. Storage limit on that aspect depends on max value for segment in address (I don't know how many bits are used to store segment number).

    http://dev.mysql.com/doc/refman/5.1/...ile-space.html

    For each page you would have less than 16KB rows due to overhead for storage of pointers to rows and row end markers. Even if you create a table with rows 1 byte in length you won't have more than 64TB rows in the table. Calculate your storage requirements, if you need more then consider other storage engines, or redesign data architecture, or put into place retention period policies for data (eg deleted after 5 years).
    Last edited by leinad31; May 24th, 2010 at 03:49 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width