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]