MySQL Forums
Forum List  »  Merge Storage Engine

Ok to write directly to member of merge table?
Posted by: Nathan Cheng
Date: May 04, 2006 06:32PM

I have a MERGE table that uses INSERT_METHOD=FIRST to insert into the first table Q. I also have processes that *directly* write into this table Q. We went live with this setup today, and it has been having lots of trouble. The table has become corrupted at least 10 times, causing everything to fail until a REPAIR TABLE Q is performed.

The MERGE table is a (connection-specific) temporary table that gets created/dropped very often, and table Q can get several writes per second coming from several different servers (so truly simultaneous writes are possible).

Am I doing something wrong for which I should accept the blame for getting my table corrupted?

We are on 4.1.18 right now, but upgrading to 4.1.19 tonight. Will this fix the problem?

Thanks,

Nathan

Options: ReplyQuote




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.