MySQL Forums
Forum List  »  MyISAM

Converting Heap to MyISAM issue
Posted by: Matija Milkovic
Date: January 11, 2015 05:33PM

At work we have a problem that has now occurred more then once.

Problem is that query is in state of converting HEAP to MyISAM and it paralyzes our server( query in this state is not able to kill itself and kill flag is not evaluated until only after the operation which seem to take FOREVER in our case)

The following global MYSQL variables appear to us:

| tmp_table_size | 17179869184 |
| max_heap_table_size | 8589934592 |

Does anyone know whether or not setting global MYSQL variables(tmp_table_size and max_heap_table_size) to the same value will prevent Converting HEAP to MyISAM (since there should never be a temporary table larger than the HEAP table size)... or will internal temporary tables not respect tmp_table_size?

Options: ReplyQuote


Subject
Views
Written By
Posted
Converting Heap to MyISAM issue
7165
January 11, 2015 05:33PM
3088
January 13, 2015 10:22AM
3571
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.