MySQL Forums
Forum List  »  Performance

Re: 5.5 results
Posted by: Miran Nadir
Date: May 11, 2021 06:58AM

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.


Options: ReplyQuote

Written By
May 06, 2021 02:17PM
May 09, 2021 11:28AM
May 09, 2021 12:27PM
May 10, 2021 01:42AM
May 10, 2021 10:17AM
May 10, 2021 11:15AM
May 10, 2021 02:39PM
Re: 5.5 results
May 11, 2021 06:58AM
May 11, 2021 11:42AM
May 11, 2021 01:14PM
May 11, 2021 02:05PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.