MySQL Forums
Forum List  »  Performance

Re: 5.7 vs 8.0 import performance
Posted by: Peter Brawley
Date: May 09, 2021 03:36PM

In local mysql clients running against MySQL 5.7 and 8.0, each on a SSD, that 21MB dump script runs in 7 secs against 5.7.33, in 20 sec against 8.0.23, but the actual Insert times are identical, eg with the bdetails table ...

----------------------------------------------------------------------------------------
  5.7                                           8.0
-----------------------------------------------------------------------------------------
Query OK, 7231 rows affected (0.20 sec)       Query OK, 7231 rows affected (0.20 sec)
Records: 7231  Duplicates: 0  Warnings: 0     Records: 7231  Duplicates: 0  Warnings: 0

Query OK, 7097 rows affected (0.11 sec)       Query OK, 7097 rows affected (0.11 sec)
Records: 7097  Duplicates: 0  Warnings: 0     Records: 7097  Duplicates: 0  Warnings: 0

Query OK, 7183 rows affected (0.09 sec)       Query OK, 7183 rows affected (0.09 sec)
Records: 7183  Duplicates: 0  Warnings: 0     Records: 7183  Duplicates: 0  Warnings: 0

Query OK, 7154 rows affected (0.11 sec)       Query OK, 7154 rows affected (0.11 sec)
Records: 7154  Duplicates: 0  Warnings: 0     Records: 7154  Duplicates: 0  Warnings: 0

Query OK, 5470 rows affected (0.09 sec)       Query OK, 5470 rows affected (0.09 sec)
Records: 5470  Duplicates: 0  Warnings: 0     Records: 5470  Duplicates: 0  Warnings: 0
----------------------------------------------------------------------------------------

... which shows that the 13-second performance difference is attributable to additional 8.0 housekeeping.



Edited 1 time(s). Last edit at 05/09/2021 07:08PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
209
May 06, 2021 02:17PM
243
May 09, 2021 11:28AM
198
May 09, 2021 12:27PM
Re: 5.7 vs 8.0 import performance
255
May 09, 2021 03:36PM
204
May 10, 2021 01:42AM
197
May 10, 2021 10:17AM
196
May 10, 2021 11:15AM
306
May 10, 2021 02:39PM
222
May 11, 2021 06:58AM
187
May 11, 2021 11:42AM
258
May 11, 2021 01:14PM
185
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.