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