Re: replication problem / myisamchk: error
You did not mention, how this "mess" shows up. I mean, what is the error that you get before you run 'myisamchk'?
Is there heavy concurrency on the master (many users)?
Do you allow write access on the slaves?
Are you aware of the following paragraph of the reference manual?
"5.8.3.7. Using myisamchk for Crash Recovery
If you run mysqld with --skip-external-locking (which is the default on some systems, such as Linux), you can't reliably use myisamchk to check a table when mysqld is using the same table."
Subject
Views
Written By
Posted
5678
June 16, 2005 03:33AM
Re: replication problem / myisamchk: error
2375
June 17, 2005 02:43AM
4331
June 17, 2005 07:22AM
2596
June 20, 2005 07:32AM
2435
June 20, 2005 08:52AM
2065
July 01, 2005 08:54AM
1948
July 17, 2005 11:28AM
2137
July 03, 2006 02:15AM
1826
July 03, 2006 03:52AM
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.