Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.8K
2 Posted Topics
A crashed table is for the MyISAM storage engine. MyISAM has two files, a .MYD (for MyISAM Data) and .MYI (for MyISAM Index). When you make a change to your table with INSERT/UPDATE/DELETE the data is flushed to disk, while the index is written to memory and not initially flushed …
You can also retrieve the information from the INFORMATION_SCHEMA.TABLES table.
The End.