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]
