[Maria-discuss] MariaDB 10.1.4 Progress output
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.campbell@tradingscreen.commailto:rhys.campbell@tradingscreen.com
Follow TradingScreen on Twitterhttp://twitter.com/#!/TradingScreen , Facebookhttp://www.facebook.com/pages/TradingScreen/214046251945650 and our blog Trading Smarter<tradingsmarter.tradingscreen.com> This message is intended only for the recipient(s) named above and may contain confidential information. If you are not an intended recipient, you should not review, distribute or copy this message. Please notify the sender immediately by e-mail if you have received this message in error and delete it from your system.
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 the other hand with the new improvenemts it don't block the application while optimize table is running)
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 and the percentage will be higher than 100%
Sent from my iPhone
On Apr 20, 2015, at 6:57 AM, Rhys Campbell Rhys.Campbell@tradingscreen.com 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?
<image001.png>
Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.campbell@tradingscreen.com
Follow TradingScreen on Twitter , Facebook and our blog Trading Smarter This message is intended only for the recipient(s) named above and may contain confidential information. If you are not an intended recipient, you should not review, distribute or copy this message. Please notify the sender immediately by e-mail if you have received this message in error and delete it from your system.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
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. If you have a test case for that behaviour, we'll fix it.
Regards, Sergei
Hi Sergei,
It seems limited to the salaries table in the employees sample database.
https://dev.mysql.com/doc/employee/en/
ALTER TABLE salaries ENGINE = Innodb; <- Exhibits the incorrect behaviour.
CREATE INDEX tt ON salaries (emp_no); <- Does not exhibit the behaviour.
DROP INDEX tt ON salaries; <- Does not exhibit the behaviour
ALTER TABLE salaries ADD id INT NULL; <- Exhibits the incorrect behaviour.
ALTER TABLE salaries DROP id; <- Exhibits the incorrect behaviour.
ALTER TABLE salaries ROW_FORMAT = COMPRESSED; <- Exhibits the incorrect behaviour.
Most of the tables have an estimated number of stages of 9/12/16/20 etc. The salaries table ranges from 76-84 depending on the action. 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:serg@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.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. If you have a test case for that behaviour, we'll fix it.
Regards,
Sergei
Hi Rhys,
On 18.05.2015 17:51, Rhys Campbell wrote:
Hi Sergei,
It seems limited to the salaries table in the employees sample database.
Thanks for the information. I can reproduce it rather easily as described; it's now been filed in JIRA on your behalf as https://mariadb.atlassian.net/browse/MDEV-8178.
I have also filed the absence of the progress report for 10.0 mentioned earlier in this thread, as I don't see right away a good reason why it shouldn't be shown: https://mariadb.atlassian.net/browse/MDEV-8179
Regards, Elena
https://dev.mysql.com/doc/employee/en/
ALTER TABLE salaries ENGINE = Innodb; <- Exhibits the incorrect behaviour.
CREATE INDEX tt ON salaries (emp_no); <- Does not exhibit the behaviour.
DROP INDEX tt ON salaries; <- Does not exhibit the behaviour
ALTER TABLE salaries ADD id INT NULL; <- Exhibits the incorrect behaviour.
ALTER TABLE salaries DROP id; <- Exhibits the incorrect behaviour.
ALTER TABLE salaries ROW_FORMAT = COMPRESSED; <- Exhibits the incorrect behaviour.
Most of the tables have an estimated number of stages of 9/12/16/20 etc. The salaries table ranges from 76-84 depending on the action. 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:serg@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.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. If you have a test case for that behaviour, we'll fix it.
Regards,
Sergei
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (5)
-
Elena Stepanova -
Justin Swanhart -
Reindl Harald -
Rhys Campbell -
Sergei Golubchik