MySQL Forums
Forum List  »  Merge Storage Engine

Merge table problems
Posted by: yoyoma
Date: October 09, 2005 05:58AM

I have recently implemented MyISAM Merge tables in 4.0.18. There are two merge tables, each comprised of 60 identical tables. Things seem to be working fine for the most part with two exceptions...


1) In the past few days there have been a few occasions where a 'ERROR: 1105 File not found' is showing up in the mysqld.log for a few of the tables. The files are there and I can even query the tables to see they are there, and empty as they should be at this point. What would be causing these errors?

2) We are using the merge tables to allow only 60 days of data to be kept. We are handling this by having the merge table insert=last and every night we modify the union clause so the first merge table is now last and truncate it. This rotation process seems to be one cause of the 'ERROR: 1105 File not found' error, but more importantly this is stopping replication on this server and also showing a 'ERROR: 1053 Server shutdown in progress' in the mysqld.log file.

Is there any reason that the merge tables would do this?

TIA

Options: ReplyQuote


Subject
Views
Written By
Posted
Merge table problems
5340
October 09, 2005 05:58AM
3644
October 17, 2005 09:23AM


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.