Bug #37168 Missing variable - skip_name_resolve

• Submitted: 3 Jun 2008 18:47
• Modified: 18 Jun 2010 1:52
• Reporter: Jason Frisvold
• Status: Closed
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 5.0.51a, 5.0.60
• OS: Linux (CentOS 5.1)
• Assigned to: Georgi Kodinov
• CPU Architecture: Any

[3 Jun 2008 18:47] Jason Frisvold

Description:
The variable skip_name_resolve does not show up in the list of variables within MySQL.  Unable to verify that this option is working.  I do have this option set in my /etc/my.cnf file.

How to repeat:
[friz@jake ~]$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3948
Server version: 5.0.51a-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%skip%";
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| skip_external_locking | ON    | 
| skip_networking       | OFF   | 
| skip_show_database    | OFF   | 
| slave_skip_errors     | OFF   | 
+-----------------------+-------+
4 rows in set (0.00 sec)

mysql> show global variables like "%skip%";
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| skip_external_locking | ON    | 
| skip_networking       | OFF   | 
| skip_show_database    | OFF   | 
| slave_skip_errors     | OFF   | 
+-----------------------+-------+
4 rows in set (0.00 sec)

Suggested fix:
Add variable to variable list, allowing the user to determine the current status of this option.

[3 Jun 2008 19:28] Valeriy Kravchuk

Current properly of skip_name_resolved is properly described at http://dev.mysql.com/doc/refman/5.0/en/privileges-options.html. So I consider this as a reasonable feature request.

[25 Jul 2008 13:56] Baron Schwartz

It's missing in 5.1 too.

[2 Oct 2008 21:17] Konstantin Osipov

Dear triage,
missing variables for server options are not feature requests.
We have resolved to fix this inconsistency.

[6 Oct 2008 20:31] Omer Barnir

Kostja: Given the above doc link and the fact that there are other documented variables that are not available in the show command, why do you see this one as a bug and not as a feature request? If you are suggesting that all variables should be included in the show command (for consistency), it is not a bad idea, but ut us a feature request).

Please clarify,

Thanks

[31 Mar 2010 13:13] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/104713

3436 Georgi Kodinov	2010-03-31
      Bug #37168: Missing variable - skip_name_resolve
      
      Added a read-only global boolean variable skip_name_resolve.

[6 Apr 2010 8:01] Bugs System

Pushed into 5.1.46 (revid:[e-mail]-20100405111026-7kz1p8qlzglqgfmu) (version source revid:[e-mail]-20100331131237-ts0pnjw9h4vlxnge) (merge vers: 5.1.46) (pib:16)

[21 Apr 2010 23:34] Paul DuBois

Noted in 5.1.46 changelog.

There is a new system variable, skip_name_resolve, that is set from
the value of the --skip-name-resolve server option. This provides a
way to determine at runtime whether the server uses name resolution 
for client connections.  

Setting report to Need Merge pending push into Celosia.

[28 May 2010 5:59] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100524190136-egaq7e8zgkwb9aqi) (version source revid:[e-mail]-20100422150750-vp0n37kp9ywq5ghf) (pib:16)

[28 May 2010 6:27] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100524190941-nuudpx60if25wsvx) (version source revid:[e-mail]-20100422150658-fkhgnwwkyugtxrmu) (merge vers: 6.0.14-alpha) (pib:16)

[28 May 2010 6:55] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100524185725-c8k5q7v60i5nix3t) (version source revid:[e-mail]-20100403173551-52r97erqowlqwkon) (merge vers: 5.5.4-m3) (pib:16)

[29 May 2010 2:38] Paul DuBois

Noted in 5.5.5, 6.0.14 changelogs.

[17 Jun 2010 12:01] Bugs System

Pushed into 5.1.47-ndb-7.0.16 (revid:[e-mail]-20100617114014-bva0dy24yyd67697) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 12:43] Bugs System

Pushed into 5.1.47-ndb-6.2.19 (revid:[e-mail]-20100617115448-idrbic6gbki37h1c) (version source revid:[e-mail]-20100609211156-tsac5qhw951miwtt) (merge vers: 5.1.46-ndb-6.2.19) (pib:16)

[17 Jun 2010 13:29] Bugs System

Pushed into 5.1.47-ndb-6.3.35 (revid:[e-mail]-20100617114611-61aqbb52j752y116) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)