MySQL Forums
Forum List  »  MyISAM

Re: Converting Heap to MyISAM issue
Posted by: Rick James
Date: January 13, 2015 10:22AM

Temporary tables use the minimum of the two values, 8GB in your case.

MEMORY tables use max_heap_table_size, which is 8GB in your case.

How much RAM do you have? I would not use 8GB for either setting unless I had a lot more than 8GB of RAM.

Setting the GLOBAL setting, then performing the conversion in the _same_ connection is useless... When you _connect_, the GLOBAL values are copied into the SESSION values. Then, the SESSION values control the limits for your actions.

How big is the table? What is the operation being performed? I would expect it to be
ALTER TABLE foo ENGINE=MyISAM;
Please provide all the details of the conversion.

8G and 16G are much too high for those settings.

Options: ReplyQuote


Subject
Views
Written By
Posted
6683
January 11, 2015 05:33PM
Re: Converting Heap to MyISAM issue
2819
January 13, 2015 10:22AM
3181
January 13, 2015 12:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.