SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Addict ibeblunt's Avatar
    Join Date
    Jan 2001
    Location
    Jersey City, NJ
    Posts
    312
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Error: The Table Is Full

    I just received this error when trying to insert a new row:
    Error performing query: The table 'SQLc601cd_0' is full.

    Currently I have 5.8GB's available. The table in question has 2245 rows of information.

    The weird thing is using phpMyAdmin I am able to add new rows. It's only when I attempt to list the information in the table that I have a problem.

    Any clues?
    Last edited by ibeblunt; Feb 15, 2001 at 09:59.
    <///////~

    www.sohh.com

  2. #2
    SitePoint Wizard
    Join Date
    Apr 2000
    Posts
    1,483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are you trying to select all the rows at once?
    How much RAM does the server have?

  3. #3
    SitePoint Addict ibeblunt's Avatar
    Join Date
    Jan 2001
    Location
    Jersey City, NJ
    Posts
    312
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It has 512MB Memory/700P3 Processor.

    I found some info on MySQL.com. It says:

    This error occurs in older MySQL versions when an in-memory temporary table becomes larger than tmp_table_size bytes. To avoid this problem, you can use the -O tmp_table_size=# option to mysqld to increase the temporary table size or use the SQL option SQL_BIG_TABLES before you issue the problematic query.

    A little more research provided me with:
    SQL_BIG_TABLES = 0 | 1
    If set to 1, all temporary tables are stored on disk rather than in memory. This will be a little slower, but you will not get the error The table tbl_name is full for big SELECT operations that require a large temporary table. The default value for a new connection is 0 (that is, use in-memory temporary tables).


    This is the query causing the issue:
    SELECT tbl_content.contentID, tbl_content.contentheadline, tbl_content.contentlive, tbl_content.contentapproved, tbl_content.contentgolive, tbl_subsection.subsection FROM tbl_content, tbl_subsection WHERE tbl_content.contentsubsectionID = tbl_subsection.subsectionID ORDER BY contentgolive DESC LIMIT 0, 20

    I know how to log in to mySQL in shell. Do I type:
    sql_big_tables = 1; at the mysql prompt? I don't wanna mess anything up.

    Also James, do you know how to view and edit the my.cnf file using shell?
    Last edited by ibeblunt; Feb 15, 2001 at 12:24.
    <///////~

    www.sohh.com


Bookmarks

Posting Permissions

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