Hi,
On Mar 24, 2005, at 6:07 PM, <[EMAIL PROTECTED]> wrote:
Mysql is telling me my Heap table is full.� Now I set it to 128M. � my.cnf line tmp_table_size = 128M
Try changing the setting called max_heap_table_size. tmp_table_size only has to do with internal temporary tables that are used to resolve a query (ie. when you see a 'Using Temporary' in the EXPLAIN)
�
� The Table filled up at 12.7M� This appears to be very close to 128M with a decimal out of place.�
Did I find a Bug?�
Am I doing something wrong?
Is the tmp_table_size a PER TABLE or for all mysql heap tables?
�
I can't seem to get past this 12.7M mark I need 128M of heap to run my looping searches with.
�
�
CREATE TABLE `fsearch_searchheap` (
� `searchAffid` int(11) NOT NULL default '0',
� `searchKeyword` varchar(100) NOT NULL default '',
� `searchReferrer` varchar(100) NOT NULL default '',
� `searchIp` varchar(15) NOT NULL default '',
� KEY `searchAffid` (`searchAffid`),
� KEY `searchKeyword` (`searchKeyword`)
) ENGINE=MEMORY DEFAULT Select * from fsearch_search;
�
�
Regards,
Harrison
-- Harrison C. Fisk, Trainer and Consultant MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster -- http://www.mysql.com/consulting/packaged/cluster.html
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
