Ok, Never mind my last statement because I didn't change anything and it worked this morning.
Next problem I copied a 21MB db to the heap and it reported 248M of data once there? Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 8:12 AM To: Harrison Fisk Cc: Mysql Subject: RE: Heap table says its Full? I took a guess at that yesterday. I left the tmp_table_size 128M added the line max_heap_table_size 500M But to no avale. Still limited in the number to 12.7M I am using 4.1.8 as installed by Cpanel. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -----Original Message----- From: Harrison Fisk [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 1:30 AM To: [EMAIL PROTECTED] Cc: Mysql Subject: Re: Heap table says its Fuul? 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
