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

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

python - Receiving "KeyError" after decoding json result from url -

c++ - Qt::make_shared for creating QSharedPtr as std::make_shared for creating std::shared_ptr -