MySQL Forums
Forum List  »  Performance

Re: Older version of MySQL server are faster than newer Versions
Posted by: Peter Brawley
Date: May 06, 2021 06:50PM

> mysqldump -uroot -prootpassword --result-file="d:\dumpeddbfile.sql" dbname

I should've started with that question---I assumed wrongly as it turns out that you had specified --extended-insert. It speeds up execution of the dump file enormously. Use it.

> Did you try to reproduce the testes which I did and measure times between 5.5 and 8.0?

5.5 is long past end-of-life, I'm no longer running an instance of it. I regularly run 20-100MB dumps against 5.7 and 8.0 installations---8.0 is slightly slower as I'd expect (it does more), but not by much. Always with --extended-insert and I've no plan to do without that.

Options: ReplyQuote


Subject
Views
Written By
Posted
279
May 06, 2021 02:17PM
291
May 09, 2021 11:28AM
250
May 09, 2021 12:27PM
249
May 10, 2021 01:42AM
239
May 10, 2021 10:17AM
237
May 10, 2021 11:15AM
350
May 10, 2021 02:39PM
262
May 11, 2021 06:58AM
236
May 11, 2021 11:42AM
306
May 11, 2021 01:14PM
250
May 11, 2021 02:05PM
Re: Older version of MySQL server are faster than newer Versions
260
May 06, 2021 06:50PM


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.