MySQL Forums
Forum List  »  Merge Storage Engine

Re: Difference between using Merge vs. symbolic-links approach?
Posted by: KimSeong Loh
Date: June 05, 2007 05:16AM

Symbolic link the table and MySQL server sees 2 different tables, locking will be an issue, since MySQL assumes both are different table, but the disk stores on the same file. MySQL server will not know there are the same file and allow both tables to be updated at the same time and possibly cause data corruption.

With MERGE table, MySQL knows that it need to lock the underlying MyISAM table when the Merget table is locked.

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.