Re: Table of type=memory is full... but not - Visolve DB Team - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRe: Table of type=memory is full... b...

From	Sent On	Attachments
John Kopanas	25 Nov 2006 07:23
John Kopanas	25 Nov 2006 09:38
Visolve DB Team	26 Nov 2006 23:11

Subject:	Re: Table of type=memory is full... but not
From:	Visolve DB Team (mysq...@visolve.com)
Date:	11/26/2006 11:11:59 PM
List:	com.mysql.lists.mysql

Hi,

Obviously True. Try mysql> show table status like 'tablename'; Check for Data_length & Max_Data_Length values which speaks about the used
memory size and allowed maximum size. The max_heap_table_size system global variable impose the maximum size of the
memory table.

Try with mysql > set GLOBAL max_heap_table_size=value; For individual tables specify MAX_ROWS table option in the CREATE TABLE or in
the ALTER TABLE.

For more Ref: http://dev.mysql.com/doc/refman/4.1/en/memory-storage-engine.html

When I moved from type=memory to the default DB it worked fine. I am starting to think that the quantity of rows i.e. 550K approx was too much for my memory on my computer to handle. Does this make sense?

On 11/25/06, John Kopanas <kopa...@gmail.com> wrote:

I create a memory table with the following query:

CREATE TABLE company_totals type=memory SELECT company_id id, SUM(annual_service_charge) service_charge FROM purchased_services ps GROUP BY company_id;")

When I try this I get the following error:

Mysql::Error: The table 'company_totals' is full:

So I decided to see what is in the table:

SELECT * FROM company_totals;

And I get the following error:

ERROR 1146 (42S02): Table 'opportunity_development.company_totals' doesn't exist

Even when I do a: SHOW TABLE STATUS the table is not listed.

So, where is this table? Why does mySQL think it is full but does not think it exists at the same time? Help :-)

http://www.kopanas.com http://www.cusec.net http://www.soen.info