Re: Changing tmpdir causes InnoDB to break
Posted by:
Rick James
Date: November 06, 2009 09:19PM
Another note: Do not set tmp_table_size too high -- it (and max_heap_table_size) control how determines when a tmp table is written to disk. Until then, it tries to create a tmp HEAP table in RAM. You setting of 1GB was causing it to allocate that much RAM, possibly causing the 'out of memory' issue previously.
I would set it to, say, 50MB. When a tmp table exceeds that, it will automatically convert to a MyISAM type and proceed.
Subject
Written By
Posted
November 05, 2009 10:16AM
November 05, 2009 10:26AM
November 06, 2009 09:15PM
Re: Changing tmpdir causes InnoDB to break
November 06, 2009 09:19PM
November 09, 2009 04:28AM
November 09, 2009 04:52AM
November 09, 2009 09:07AM
November 11, 2009 03:19AM
November 11, 2009 03:37AM
November 11, 2009 08:59PM
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.