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 Thanks ViSolve DB Team. ----- Original Message ----- From: "John Kopanas" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Saturday, November 25, 2006 11:09 PM Subject: Re: Table of type=memory is full... but not > 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 <[EMAIL PROTECTED]> 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 :-) >> >> -- >> John Kopanas >> [EMAIL PROTECTED] >> >> http://www.kopanas.com >> http://www.cusec.net >> http://www.soen.info >> > > > -- > John Kopanas > [EMAIL PROTECTED] > > http://www.kopanas.com > http://www.cusec.net > http://www.soen.info > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
