Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Unanswered: Temporary table is full

    Hi to all,

    During executing SELECT query, MySQL creates disk temporary table.
    After the tabe exceeds 4GB I get table is full error.
    How can I change settings to remove 4 GB bareer from disk tmp tables?
    I have ext3 filesystem.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    The 4G is the limit size of your filesystem.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Oct 2004
    Posts
    4
    but on a phisical table i can set max size over 4 GB, so it's not fs problem

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    What do you mean by phisical table
    A table in MyIsam has 3 files:
    Index
    Data
    FRM

    You says that the data file (MYD) is larger than 4GB ?
    Perhaps are you using INNODB ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  5. #5
    Join Date
    Oct 2004
    Posts
    4
    yes, it's possible to override 4GB data limit by increase MAX_ROWS on MyISAM table, but disk tmp tables MySQL creates automatically and I can't find settings for them

Posting Permissions

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