, September 27, 2012 1:20 PM
To: Rick James
Cc: mysql mailing list
Subject: checking progress of alter table on an InnoDB table (Was:
Re:
checking progress of alter table on a MyISAM table)
So we changed the table from MyISAM to InnoDB. I read that the 'undo
log entries
Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
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
on an InnoDB table (Was: Re:
checking progress of alter table on a MyISAM table)
So we changed the table from MyISAM to InnoDB. I read that the 'undo
log entries' shown in 'show engine innodb status' would correspond to
the number of rows that have been operated on throughout the process
Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Thursday, September 27, 2012 1:20 PM
To: Rick James
Cc: mysql mailing list
Subject: checking progress of alter table on an InnoDB table (Was: Re:
checking progress of alter table on a MyISAM table)
So we changed the table
-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Thursday, September 27, 2012 1:20 PM
To: Rick James
Cc: mysql mailing list
Subject: checking progress of alter table on an InnoDB table (Was: Re:
checking progress of alter table on a MyISAM table)
So we changed the table
(Was: Re:
checking progress of alter table on a MyISAM table)
So we changed the table from MyISAM to InnoDB. I read that the 'undo
log entries' shown in 'show engine innodb status' would correspond to
the number of rows that have been operated on throughout the process of
the ALTER. The table
on an InnoDB table (Was: Re:
checking progress of alter table on a MyISAM table)
So we changed the table from MyISAM to InnoDB. I read that the 'undo
log entries' shown in 'show engine innodb status' would correspond to
the number of rows that have been operated on throughout the process
, September 27, 2012 1:20 PM
To: Rick James
Cc: mysql mailing list
Subject: checking progress of alter table on an InnoDB table (Was:
Re:
checking progress of alter table on a MyISAM table)
So we changed the table from MyISAM to InnoDB. I read that the 'undo
log entries' shown
Am 27.09.2012 23:15, schrieb Larry Martell:
Indexes are slowing this down. your calculation of 79 hours should be
correct, only if there are no unique indexes, otherwise this will slow down
more as the data increases.
It is what it is - there's no free lunch - dropping the indexes, doing
I try to figure out something observing the stats with SHOW STATUS. There are
some reads, writes, etc that tell something about what is going on.
Looking just at the file sizes is likely going to not tell much about the
progress.
If there is a better way to monitor this progress, I would
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:
.
-Original Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
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
2012/09/26 09:31 -0700, Rick James
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
13 matches
Mail list logo