MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Older version of MySQL server are faster than newer Versions
1608
Miran Nadir
May 03, 2021 06:39AM
Re: Older version of MySQL server are faster than newer Versions
455
Peter Brawley
May 03, 2021 11:01AM
Re: Older version of MySQL server are faster than newer Versions
527
Miran Nadir
May 03, 2021 12:20PM
Re: Older version of MySQL server are faster than newer Versions
435
Peter Brawley
May 03, 2021 04:22PM
Re: Older version of MySQL server are faster than newer Versions
466
Miran Nadir
May 03, 2021 06:52PM
Re: Older version of MySQL server are faster than newer Versions
433
Peter Brawley
May 03, 2021 07:35PM
Re: Older version of MySQL server are faster than newer Versions
387
Miran Nadir
May 04, 2021 01:28AM
Re: Older version of MySQL server are faster than newer Versions
477
Peter Brawley
May 04, 2021 01:06PM
Re: Older version of MySQL server are faster than newer Versions
441
Miran Nadir
May 05, 2021 12:32PM
Re: Older version of MySQL server are faster than newer Versions
407
Miran Nadir
May 06, 2021 12:22PM
Re: Older version of MySQL server are faster than newer Versions
376
Peter Brawley
May 06, 2021 12:38PM
Re: Older version of MySQL server are faster than newer Versions
403
Miran Nadir
May 06, 2021 12:51PM
Re: 5.5 results
437
Peter Brawley
May 06, 2021 02:17PM
Re: 5.5 results
404
Peter Brawley
May 09, 2021 11:28AM
Re: 5.5 results
380
Miran Nadir
May 09, 2021 12:27PM
Re: 5.7 vs 8.0 import performance
498
Peter Brawley
May 09, 2021 03:36PM
Re: 5.5 results
363
Miran Nadir
May 10, 2021 01:42AM
Re: 5.5 results
369
Peter Brawley
May 10, 2021 10:17AM
Re: 5.5 results
352
Miran Nadir
May 10, 2021 11:15AM
Re: 5.5 results
455
Peter Brawley
May 10, 2021 02:39PM
Re: 5.5 results
405
Miran Nadir
May 11, 2021 06:58AM
Re: 5.5 results
370
Peter Brawley
May 11, 2021 11:42AM
Re: 5.5 results
446
Miran Nadir
May 11, 2021 01:14PM
Re: 5.5 results
373
Peter Brawley
May 11, 2021 02:05PM
Re: Older version of MySQL server are faster than newer Versions
437
Peter Brawley
May 06, 2021 01:54PM
Re: Older version of MySQL server are faster than newer Versions
444
Peter Brawley
May 06, 2021 02:24PM
Re: Older version of MySQL server are faster than newer Versions
374
Peter Brawley
May 06, 2021 02:38PM
Re: Older version of MySQL server are faster than newer Versions
425
Miran Nadir
May 06, 2021 04:54PM
Re: Older version of MySQL server are faster than newer Versions
380
Peter Brawley
May 06, 2021 06:50PM
Re: Older version of MySQL server are faster than newer Versions
360
Miran Nadir
May 07, 2021 02:58AM
Re: Older version of MySQL server are faster than newer Versions
395
Peter Brawley
May 07, 2021 09:30AM
Re: Older version of MySQL server are faster than newer Versions
381
Miran Nadir
May 07, 2021 11:21AM
Re: Older version of MySQL server are faster than newer Versions
409
Miran Nadir
May 07, 2021 03:15AM


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.