MySQL Forums
Forum List  »  Memory Storage Engine

How to allocate more memory for HEAP tables?
Posted by: Jack Ling
Date: April 27, 2005 12:56AM

Hi,


When I load data with over 10,000 records into a HEAP table, it generates an error:
ERROR 1114(HY000) THE TABLE 'XXX' IS FULL.

Where can I see how much RAM memory is allocated for mysql HEAP purposes? And how can I tune to allocate more memory for this to accomodate?

Besides, when I upload the data to the tables, there are some number of WARNINGS. How can I the details of it to determine what's wrong?

thanks a lot.
jack ling

Options: ReplyQuote


Subject
Views
Written By
Posted
How to allocate more memory for HEAP tables?
18560
April 27, 2005 12:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.