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
4623
June 29, 2008 02:12PM
Re: How to determine if table is locked or corrupted
2048
June 30, 2008 07:07AM
1925
June 30, 2008 08:27AM
1857
June 30, 2008 09:56AM
1806
June 30, 2008 10:11AM
2092
June 30, 2008 10:27AM
1729
June 30, 2008 10:44AM
1764
July 01, 2008 01:52AM
1831
July 01, 2008 09:27AM
1755
July 02, 2008 02:19AM
2070
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.