MySQL Forums
Forum List  »  Performance

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

Strange, i specifically edited the my.ini and disabled the binary-log and then restarted the server before doing anything.

However, I did edit the my.ini again and restarted the server and then checked the variable log-bin in the MySQL command line and it is now set to Zero, then I performed the restore again.
this time I got 111 seconds and 110 seconds in two consecutive tests, just a little better but not that much improvement.

see the variable below:

mysql> SELECT @@GLOBAL.log_bin, @@GLOBAL.version, @@GLOBAL.version_comment, @@GL
OBAL.version_compile_os;
+------------------+------------------+------------------------------+----------
-------------------+
| @@GLOBAL.log_bin | @@GLOBAL.version | @@GLOBAL.version_comment | @@GLOBAL.
version_compile_os |
+------------------+------------------+------------------------------+----------
-------------------+
| 0 | 8.0.24 | MySQL Community Server - GPL | Win64
|
+------------------+------------------+------------------------------+----------
-------------------+
1 row in set (0.00 sec)

mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
557
May 06, 2021 02:17PM
514
May 09, 2021 11:28AM
496
May 09, 2021 12:27PM
470
May 10, 2021 01:42AM
463
May 10, 2021 10:17AM
452
May 10, 2021 11:15AM
562
May 10, 2021 02:39PM
502
May 11, 2021 06:58AM
477
May 11, 2021 11:42AM
538
May 11, 2021 01:14PM
499
May 11, 2021 02:05PM
Re: Older version of MySQL server are faster than newer Versions
487
May 07, 2021 11:21AM


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.