MySQL Forums
Forum List  »  Performance

Re: Older version of MySQL server are faster than newer Versions
Posted by: Miran Nadir
Date: May 07, 2021 03:15AM

Hi again,
I have done another test, I did the dumping of the database again with the --extended-insert option just in case.

then restored the dumped file using the commands I mentioned before
mysql> use mysqldumpdatabasename;
mysql> set @str=now();source d:\mysqldumpdatabasename.sql;SELECT TIMESTAMPDIFF(SECOND,@str,now());

and I got the same results, it tool (133 seconds) more than two minutes to restore the database.

Options: ReplyQuote


Subject
Views
Written By
Posted
882
May 06, 2021 02:17PM
1643
May 09, 2021 11:28AM
719
May 09, 2021 12:27PM
702
May 10, 2021 01:42AM
1463
May 10, 2021 10:17AM
696
May 10, 2021 11:15AM
814
May 10, 2021 02:39PM
1907
May 11, 2021 06:58AM
711
May 11, 2021 11:42AM
765
May 11, 2021 01:14PM
1885
May 11, 2021 02:05PM
Re: Older version of MySQL server are faster than newer Versions
725
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.