I don't know the official way that Microsoft recommends adding a new ip address to the network configuration panels, and I don't know how you would do it with SQL Server 2008, I've only worked with SQL Server 2012+, so take these with a grain of salt.
For reference, here's Microsoft's page on editing the TCP/IP properties panels - https://docs.microsoft.com/...
you have one of the cases where the optimizer searching for a good solution costs much more time than the query it self, but that can change with increasing numbers.
You should read about what this optimization switch does.
if you need more speed you can try if one of https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html work better. ...
You need specify like this in my.cnf file :
Note: Make sure it is under [mysqld] section.
Keeping in mind only changing default_authentication_plugin won't allow user to login, because it will still use the old authentication plugin using which the user was create.
To change to the plugin to need to follow ...