Re: 5.5 results

[Miran Nadir]

Hi Peter,
See my answers below please.
Peter Brawley Wrote:
-------------------------------------------------------
> (i) I can't reproduce your slow dump insert
> performance---even on an ancient PC with slow hard
> disks, your 21MB import file runs in 30 secs under
> MySQL 8.0
You already reproduced it.

>
> (ii) the actual insert speeds in 5.7 and 9.0 are
> nearly identical, the speed diff from 5.7 to 8.0
> is due to background housekeeping, which in turn
> reflects improved functionality in 8.0.

Double the time required here.

>
> Why your PC is unusually slow, I can't tell from
> here. If it once ran 5.5, it's an old machine, but
> the PC I just reported on is also old.
>

I am going to record the entire experiment and put it on youtube and share the link with you.
by the entire experiment, I mean installing every server version from 5.0 till 8.0 and doing the same database restore.
Would you like that?

> So if you wish to improve dumpfile insert speed,
> the options open to you appear to be (i) use mysql
> shell and its parallel processing functionality,
> (ii) replace your hard disk with an SSD, and/or
> (iii) get a new PC.

I don't have a problem with 5.5 and I won't be upgrading to the other versions until they are at the same performance or slightly more.

regards,
Miran.