For example, for a 2 CPU quad-core machine, this setting should be set to 2 CPU * 4 Cores * 2 = 16. Set this to 2 * CPU cores of the database server.
This setting should be set large enough so that MySQL can smooth out peak loads by keeping transactions in the redo log. This setting controls how much redo logs MySQL keeps. The larger it is, the better performant the application will be due to caching at the database level. This setting controls how much of the database structure can be kept in memory. Set this to 70-75% of the available RAM of the database server, but not higher. These settings can be set in the MySQL options file see the MySQL documentation to locate this file on your operating system. It is recommended that you change the following MySQL settings to improve its performance.
The default installation of MySQL is not tuned to run on a dedicated high-end machine.
0 kommentar(er)
