# If you want to know the options a program supports, start the program # In this file, you can use all long options that the program supports. # And then execute this in a command line shell to start the server, e.g. # mysqld -install MySQLXY -defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini" # To install the server as a Windows service manually, execute this in a # mysqld -defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini" # To run the server from the command line, execute this in a # make sure the server reads the config file use the startup option C:\Program Files\MySQL\MySQL Server X.Y). # On Windows you should keep this file in the installation directory # ~/.my.cnf to set user-specific options. # mysql-data-dir/my.cnf to set server-specific options # On Linux you can copy this file to /etc/my.cnf to set global options, # Generated by the MySQL Server Instance Configuration Wizard # MySQL Server Instance Configuration File My full my.ini configuration is below : # Other default tuning values Like I mentioned before, the on-premise VM is Linux-based and the Azure VM is running on Windows - could that be a problem? I can't find any definitive proof that MySQL on Windows will cause such severe performance degradation. Is there some setting like innodb_buffer_pool_size` to allocate some amount of CPU to the MySQL Server?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |