This worked. Thanks very much for your help!
Charles
On 12/1/06, mos <[EMAIL PROTECTED]> wrote:
At 05:37 PM 11/30/2006, Charles Danko wrote:
>Hi,
>
>I am trying to write a new table into main memory, but I am getting an
out
>of memory error.
>
>Each entry consists of 2 medium_int and 1 tiny_
At 05:37 PM 11/30/2006, Charles Danko wrote:
Hi,
I am trying to write a new table into main memory, but I am getting an out
of memory error.
Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
contains just over 100,000,000 rows. By my count, this makes just over
700MB
Hi,
Thanks for the responses!
I am creating the table from an existing (MyISAM) table using the command:
CREATE TABLE memRAW (mID SMALLINT NOT NULL, pID MEDIUMINT NOT NULL, mp
TINYINT NOT NULL) ENGINE = MEMORY SELECT * FROM RAW;
The error that I get is in the MySQL client application:
ERROR 11
Hi Charles,
Charles Danko wrote:
Each entry consists of 2 medium_int and 1 tiny_int variables, and the
table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The machine I am using has 2GB, but I am still getting an
out of memory error. What am I doing wr
Charles Danko wrote:
> Hi,
>
> I am trying to write a new table into main memory, but I am getting an out
> of memory error.
>
> Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
> contains just over 100,000,000 rows. By my count, this makes just over
> 700MB of data.
Hi,
I am trying to write a new table into main memory, but I am getting an out
of memory error.
Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The machine I am using has 2GB, but
