Hello.
Setting this variable has no effect on any existing MEMORY table, unless the table is re-created with a statement such as CREATE TABLE or TRUNCATE TABLE, or altered with ALTER TABLE. [EMAIL PROTECTED] wrote: > 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] > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
