List:General Discussion« Previous MessageNext Message »
From:Rick James Date:September 26 2012 4:31pm
Subject:RE: checking progress of alter table on a MyISAM table
View as plain text  
Not really.
You could look at the .TYD and .TYI file sizes and compare to the .MYD and .MYI, but that can be deceptive.  If the table is really big, and has lots of indexes, the generation of the indexes might go slower and slower -- hence any math on the sizes would be optimistic.

> -----Original Message-----
> From: Larry Martell [mailto:larry.martell@stripped]
> Sent: Wednesday, September 26, 2012 8:52 AM
> To: mysql mailing list
> Subject: checking progress of alter table on a MyISAM table
> 
> Is there any way to check on the progress of a long running alter table
> on a MyISAM table? I know it can be done with an InnoDB table, but I
> haven't found a way to do it on with a MyISAM table.
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
checking progress of alter table on a MyISAM tableLarry Martell26 Sep
  • RE: checking progress of alter table on a MyISAM tableRick James26 Sep
    • RE: checking progress of alter table on a MyISAM tablehsv27 Sep
      • Re: checking progress of alter table on a MyISAM tableKaren Abgarian28 Sep