Re: Older version of MySQL server are faster than newer Versions

[Miran Nadir]

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>