MySQL Forums
Forum List  »  Performance

Re: 5.5 results
Posted by: Peter Brawley
Date: May 10, 2021 02:39PM

(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

(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.

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.

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
108
May 06, 2021 02:17PM
153
May 09, 2021 11:28AM
105
May 09, 2021 12:27PM
103
May 10, 2021 01:42AM
109
May 10, 2021 10:17AM
103
May 10, 2021 11:15AM
Re: 5.5 results
130
May 10, 2021 02:39PM
124
May 11, 2021 06:58AM
96
May 11, 2021 11:42AM
144
May 11, 2021 01:14PM
98
May 11, 2021 02:05PM


Sorry, only registered users may post in this forum.

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.