Re: Repairing a table
Ian Barnes wrote: Im having another problem with a large db. I have a 160Gig drive dedicated to the database partition and I have on database in particular that is taking up the space. My .MYD is 78Gig and my .MYI is 34 gig. Thats fine i have a couple of gig left, but whenever i try and do anything on it, the disk fills up and I have to run a repair table tablename quick to get it going and that takes forever since its quite large. What kind of filesystem is this? I suggest running Linux, and using a "sensible" filesystem like XFS, possibly Repairing tables take a long time usually (Falcon is meant to fix this)... Do you know why the disk is filling up so fast? What MySQL version is this? And how much *actual* free space do you have? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Repairing a table
Hi, Im having another problem with a large db. I have a 160Gig drive dedicated to the database partition and I have on database in particular that is taking up the space. My .MYD is 78Gig and my .MYI is 34 gig. Thats fine i have a couple of gig left, but whenever i try and do anything on it, the disk fills up and I have to run a repair table tablename quick to get it going and that takes forever since its quite large. Is there any other way that I could repair the index's quickly without having to wait up to 48 hours for the index to repair? Also, if i run out of diskspace, is there any way that I can get it working without truncating the data? Thanks alot Ian
Re: Repairing a table?
> > I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I > > searched the documentation on the site, but it doesn't seem to pertain to this > > version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can > > figure out what it might break. Does anyone have the steps that will allow me > > to repair a db table for 3.22.32? > The documentation that you should use when you have an older version > of mysql is the documentation that came with your copy. > > You should do this to replair a table > > shutdown the mysqld daemon > isamchk -r .ISM > > make sure everything is repaird according to isamchk ouput > > start the mysqld daemon. my problem with the docs on the site was that they said myisamchk and the rpms for 3.22 had isamchk, so of course that command doesn't work, heheh. Thanks. The table is repaired and working once again. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Repairing a table?
[EMAIL PROTECTED] wrote: > > I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I > searched the documentation on the site, but it doesn't seem to pertain to this > version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can > figure out what it might break. Does anyone have the steps that will allow me > to repair a db table for 3.22.32? > The documentation that you should use when you have an older version of mysql is the documentation that came with your copy. You should do this to replair a table shutdown the mysqld daemon isamchk -r .ISM make sure everything is repaird according to isamchk ouput start the mysqld daemon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Repairing a table?
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I searched the documentation on the site, but it doesn't seem to pertain to this version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can figure out what it might break. Does anyone have the steps that will allow me to repair a db table for 3.22.32? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php