Hi all,
Sounds like a max heap table size reached :
mysql> show variables like '%heap%';
+---------------------+----------+
| Variable_name | Value |
+---------------------+----------+
| max_heap_table_size | 16777216 |
+---------------------+----------+
1 row in set (0.00 sec)
if you redefine it, it may work better in memory.
Else use temporary tables.
Mathias
-----Original Message-----
From: Jigal van Hemert [mailto:jigal@stripped]
Sent: dimanche 24 avril 2005 17:08
To: mickalo@stripped
Cc: MySQL List
Subject: Re: Table handler errors
> Yes, I've going through the docs and the manual i have hear locally,
couldn't
> really find a specific reason and/or causing for the error. The table
type
that
> was causing the error was a HEAP table, changed it to a MyISAM table
type
and
> the error disappeared, no more handler errors now... go figure!
HEAP tables are stored in memory....
http://dev.mysql.com/doc/mysql/en/memory-storage-engine.html
Error 12 may be Out of memory? Which would explain the error...
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
