Skip navigation links

MySQL Forums :: MyISAM :: Table marked as crashed and last (automatic?) repair failed


Advanced Search

Re: Table marked as crashed and last (automatic?) repair failed
Posted by: Rick James ()
Date: March 04, 2011 08:21AM

The entire tree: Everything under /.../mysql/..., including
mysql/mysql/ -- where the GRANTs are stored (user, db, host, ...)
mysql/yourdb/ -- directories corresponding to your database(s)
mysql/ibdata1 (or wherever it is) -- critical stuff for InnoDB
mysql/iblog* -- ditto
etc

If you copy my.cnf (my.ini), be sure to change server_id -- that value MUST be different between machines.

The leaf nodes of the BTree (InnoDB):
* For the 'data' -- contains entire rows
* For a secondary 'index' -- contains the PRIMARY KEY: It then uses this to find the actual record by drilling down the Data BTree.
Those two structures are virtually identical; it's just a question of what you find when you get to the leaf.

MyISAM uses a BTree for each index, including the PK, but not for the data. Its leaf nodes have pointers into the data file (.MYD). All the indexes are in the .MYI file. The MYD is just data; virtually no structure. (There is a little bit of structure to handle deleted rows.)

Options: ReplyQuote


Subject Views Written By Posted
Table marked as crashed and last (automatic?) repair failed 7012 newbie Shai 02/23/2011 08:39AM
Re: Table marked as crashed and last (automatic?) repair failed 2412 Rick James 02/24/2011 03:50PM
Re: Table marked as crashed and last (automatic?) repair failed 2115 newbie Shai 02/24/2011 09:05PM
Re: Table marked as crashed and last (automatic?) repair failed 1874 Rick James 02/25/2011 07:50AM
Re: Table marked as crashed and last (automatic?) repair failed 1480 newbie Shai 02/25/2011 07:56PM
Re: Table marked as crashed and last (automatic?) repair failed 3176 Rick James 02/25/2011 08:43PM
Re: Table marked as crashed and last (automatic?) repair failed 1346 newbie Shai 03/02/2011 11:02AM
Re: Table marked as crashed and last (automatic?) repair failed 1041 Rick James 03/03/2011 11:13PM
Re: Table marked as crashed and last (automatic?) repair failed 1075 newbie Shai 03/04/2011 12:53AM
Re: Table marked as crashed and last (automatic?) repair failed 3141 Rick James 03/04/2011 08:21AM
Re: Table marked as crashed and last (automatic?) repair failed 1226 newbie Shai 03/04/2011 10:27AM
Re: Table marked as crashed and last (automatic?) repair failed 1772 Rick James 03/04/2011 08:29PM
Re: Table marked as crashed and last (automatic?) repair failed 1066 newbie Shai 03/04/2011 10:25PM
Re: Table marked as crashed and last (automatic?) repair failed 1375 Rick James 03/05/2011 03:55PM
Re: Table marked as crashed and last (automatic?) repair failed 1460 newbie Shai 03/06/2011 06:30PM


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.