mysql - How to configure my.cnf in 5.6.17? -
On the production server (linux machine mysql 5.6.17), I tried c.cf to search for system variables , But My.cnf /etc/my.cnf was not in place. It was in the USR / directory Also in that file only comments are as follows -
Remove # major # and most important data Set the quantity of RAM for # # MySQL starts with 70% of total RAM for dedicated server and 10% please tell me my.cnf I can copy and how can I change the variables like - innodb_buffer_pool_size = 200M max_connections = 300 < Div class = "post-text" itemprop = "text">
There are several ways in which you can modify the global variable.
Its Mary. In the Cf file, add / edit values under the
[mysqld] block; [mysqld] innodb_buffer_pool_size = 200M max_connections = 300 Then restart the mysqld daemon to change the change. Run a query
You can run the following questions to change the values of those variables, but once the mysqld daemon restarts / reboots the server / Etc. will be reset. SET global innodb_buffer_pool_size = 200M; Set global max_connection = 300; You can read more about this here:
Comments
Post a Comment