ion. Often, halfway
through, the number of steps will drop down to 22.
[cid:image001.png@01D09182.7BFC1B40]
Cheers,
Rhys
-Original Message-
From: Sergei Golubchik [mailto:s...@mariadb.org]
Sent: 16 May 2015 09:54
To: Rhys Campbell
Cc: maria-discuss@lists.launchpad.net
Sub
: Sergei Golubchik [mailto:s...@mariadb.org]
Sent: 16 May 2015 09:54
To: Rhys Campbell
Cc: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] MariaDB 10.1.4 Progress output
Hi, Rhys!
On Apr 20, Rhys Campbell wrote:
> Note the progress output below. I've seen several like this. i
Hi, Rhys!
On Apr 20, Rhys Campbell wrote:
> Note the progress output below. I've seen several like this. i.e...
>
> Stage: 1 of 72 'altering table' 350% of stage done. Is this intentional?
No, not exactly :)
This happens when the engine miscalculates number of steps it needs to
do for an ALTER.
I have not looked at the code, but my guess is InnoDB row count from SE is
being used, which is approximate and can sometimes differ by an order of
magnitude or more from the actual row count. If the estimate is significantly
lower than real value, you will copy many more rows than the estimate
Am 20.04.2015 um 15:57 schrieb Rhys Campbell:
Note the progress output below. I’ve seen several like this. i.e…
Stage: 1 of 72 ‘altering table’ 350% of stage done. Is this intentional?
well, 10.0.17 don't show any progress here for alter / optimize large
innodb tables tables while 5.5 did (on
Note the progress output below. I've seen several like this. i.e...
Stage: 1 of 72 'altering table' 350% of stage done. Is this intentional?
[cid:image001.png@01D07B7A.526BD6D0]
Rhys Campbell
Database Administrator
TradingScreen, Inc.
23 York House, 5th Floor
London WC2B 6UJ
Email: rhys.campb..
6 matches
Mail list logo
