maria-discuss team mailing list archive

[Elena Stepanova <elenst@xxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxx]
> Sent: 16 May 2015 09:54
> To: Rhys Campbell
> Cc: maria-discuss@xxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp