Bug #71219 Please make skip_name_resolve a dynamic setting
Submitted: 23 Dec 2013 15:31 Modified: 22 Mar 2014 9:42
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.6.14 OS:Any
Assigned to: CPU Architecture:Any
Tags: configuration, dynamic, variables

[23 Dec 2013 15:31] Simon Mudd 
Description:
Please make this setting dynamic. Having to stop the server to change this is inconvenient.

How to repeat:
mysql> set global skip_name_resolve = 1;
ERROR 1238 (HY000): Variable 'skip_name_resolve' is a read only variable

Suggested fix:
Please make this setting dynamic. Having to stop the server to change this is inconvenient.
Many people suggest the use of this setting as it avoids possible problems with DNS but the setting is not dynamic. It's more convenient to see hostnames, and having the option to switch between the 2 settings to see if this makes a performance difference or to resolve a temporary problem in the DNS infrastructure would be very helpful.

The more dynamic variables you have the more you reduce the need to shutdown the mysql instance. That's good as sometimes having to shutdown a server for a minor change like this is really very inconvenient.
[24 Dec 2013 18:41] MySQL Verification Team 
Thank you for the bug report.