Announcement

Collapse
No announcement yet.

4Gb post table limit?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 4Gb post table limit?

    On a test forum of mine I've been doing some scaling tests and my post table is about 4.1Gb and now when I try to insert more data I get an error that says
    mysql error: The table 'post' is full

    mysql error number: 1114

    Is this something that's been covered here before cause I can't find an answer in the searches I've done so far.
    Gamscript V1.2 released!Purchase Demo Arcade

  • #2
    http://dev.mysql.com/doc/mysql/en/Full_table.html
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      The most probable reason would be that the operating system's file size limit has been reached, especially since your table is 4 gb large. I don't think there's anything that can be done short of recompiling the kernel and specifying a larger file size limit.

      Comment


      • #4
        This ended up working great for me:

        ALTER TABLE post MAX_ROWS=1000000000

        Any recent OS will support above 4.1Gb files without recompiling the kernel. The test forum I'm putting together currently has a 6Gb post table and growing rather quickly.
        Gamscript V1.2 released!Purchase Demo Arcade

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X