Heap table says its Fuul?

[gunmuse]

Mysql is telling me my Heap table is full.  Now I set it to 128M.   my.cnf line tmp_table_size = 128M     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;       Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183