You are here: Home > Linux, Tips&Info > How to change mysql parameter without restart mysql?

How to change mysql parameter without restart mysql?

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.

Tags: , ,

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS

One Response to “How to change mysql parameter without restart mysql?”

  1. Great post. I am a normal visitor of your website and appreciate you taking the time to maintain the nice site. I’ll be a regular visitor for a long time.