MySQL Forums
Forum List  »  Memory Storage Engine

table is full
Posted by: scott hathaway
Date: November 06, 2007 09:05AM

I am trying to get a table into memory with the following:

create table ws_mem engine=memory as select * from winsite_report1

I get the error: 1114 The table 'ws_mem' is full

I am using the latest MySQL 64 bit for Windows and have 16GB of RAM on the server.

Here is my my.ini:
[client]
port=3306

[mysql]
default-character-set=utf8

[mysqld]
port=3306
basedir="D:/mysql/"
datadir="D:/mysql/Data/"
default-character-set=utf8
default-storage-engine=myisam
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=160
query_cache_size=2000M
table_cache=320
tmp_table_size=8000M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=1000M
key_buffer_size=1000M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K

Can anyone help me get this table into memory?
Thanks,
Scott

Options: ReplyQuote


Subject
Views
Written By
Posted
table is full
17388
November 06, 2007 09:05AM


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.