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]
RE: Heap table says its Full?
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]
Re: Heap table says its Full?
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]
