Re: How to determine if table is locked or corrupted
SHOW TABLE STATUS is always useful, or SHOW TABLE STATUS WHERE name = 'users'.
The command OPTIMIZE TABLE will rebuild the table as a copy of your original. (In InnoDB only. MyISAM does something else with this command.) This is the best way of dealing with corruption.
Ben
Subject
Views
Written By
Posted
4628
June 29, 2008 02:12PM
Re: How to determine if table is locked or corrupted
2051
June 30, 2008 07:07AM
1927
June 30, 2008 08:27AM
1859
June 30, 2008 09:56AM
1808
June 30, 2008 10:11AM
2094
June 30, 2008 10:27AM
1731
June 30, 2008 10:44AM
1766
July 01, 2008 01:52AM
1834
July 01, 2008 09:27AM
1758
July 02, 2008 02:19AM
2073
June 30, 2008 09:40AM
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.