Digital Journal » change mysql parameter http://digitaljournal.sg/wp My Digital Journal Mon, 20 Oct 2014 00:32:27 +0000 en-US hourly 1 http://wordpress.org/?v=3.4.2 How to change mysql parameter without restart mysql? http://digitaljournal.sg/wp/?p=47 http://digitaljournal.sg/wp/?p=47#comments Thu, 27 Sep 2012 10:27:25 +0000 admin http://digitaljournal.sg/wp/?p=47 Try these single and simple command from your mysql cli, to change mysql global parameter on the fly (it’s means no need to restart the service)

mysql> set global max_connections=400;

you can check the results using this command

mysql> show global variables;

always be reminded that parameter has been setup using above command will be not persist across restart, you need to put the parameter in /etc/my.cnf so the changes will persist across reboot.

]]> http://digitaljournal.sg/wp/?feed=rss2&p=47 1