MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: Table marked as crashed and last (automatic?) repair failed
Posted by: Rick James
Date: February 25, 2011 07:50AM

True, InnoDB tablespaces do not give freed blocks back to the operating system. This is rarely a problem, because tables rarely shrink permanently. innodb_file_per_table should be ON so that the problem can be isolated to individual tables; then rebuilding a table can free up its wasted space.

SHOW CREATE TABLE -- so I can give specific advice.

Specific issues to look for when converting from MyISAM to InnoDB:
http://mysql.rjweb.org/doc.php/myisam2innodb

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Table marked as crashed and last (automatic?) repair failed
12198
newbie Shai
February 23, 2011 08:39AM
Re: Table marked as crashed and last (automatic?) repair failed
3905
Rick James
February 24, 2011 03:50PM
Re: Table marked as crashed and last (automatic?) repair failed
3251
newbie Shai
February 24, 2011 09:05PM
Re: Table marked as crashed and last (automatic?) repair failed
2944
Rick James
February 25, 2011 07:50AM
Re: Table marked as crashed and last (automatic?) repair failed
2706
newbie Shai
February 25, 2011 07:56PM
Re: Table marked as crashed and last (automatic?) repair failed
5851
Rick James
February 25, 2011 08:43PM
Re: Table marked as crashed and last (automatic?) repair failed
2487
newbie Shai
March 02, 2011 11:02AM
Re: Table marked as crashed and last (automatic?) repair failed
1960
Rick James
March 03, 2011 11:13PM
Re: Table marked as crashed and last (automatic?) repair failed
1993
newbie Shai
March 04, 2011 12:53AM
Re: Table marked as crashed and last (automatic?) repair failed
4582
Rick James
March 04, 2011 08:21AM
Re: Table marked as crashed and last (automatic?) repair failed
2173
newbie Shai
March 04, 2011 10:27AM
Re: Table marked as crashed and last (automatic?) repair failed
2654
Rick James
March 04, 2011 08:29PM
Re: Table marked as crashed and last (automatic?) repair failed
1922
newbie Shai
March 04, 2011 10:25PM
Re: Table marked as crashed and last (automatic?) repair failed
2335
Rick James
March 05, 2011 03:55PM
Re: Table marked as crashed and last (automatic?) repair failed
2565
newbie Shai
March 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.