MySQL Forums
Forum List  »  Memory Storage Engine

Overflowing memory engine
Posted by: Paul Hirose
Date: August 23, 2010 04:53PM

I was wondering what happens if I try to insert more into a memory-engine table than the max_heap_table_size or tmp_table_size. I doubt I will :) but given the volatile nature of the data, it's vaguely possible during a huge "rush" that we might hit it.

Does the insert simply fail, or otherwise gracefully fail somehow? I'm trying to insert data into my db until it fails, but I thought I'd also ask.

This is MySQL 5.0.77 64bit on RHEL 5.5 64bit.

Thank you,

Options: ReplyQuote

Written By
Overflowing memory engine
August 23, 2010 04:53PM

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.