Optimizing MySQL when opening skip-name-resolve parameters

Source: Internet
Author: User
Tags mysql command line

parameter use:
skip-name-resolve #禁止MySQL对外部连接进行DNS解析skip-grant-tables

To Add the--skip-name-resolve method:
1
2
3
4 ......
Modify the configuration file additions and require a restart.

parameter optimization:
The purpose of the Skip-name-resolve parameter is to no longer reverse-parse (IP does not reverse into a domain name), which can speed up the response time of the database.
internal DNS server, the IP of each server to do a reverse resolution, but not the internal IP to do reverse resolution, so use Skip-name-resolve after using the intranet address to the MYSQLSLAP request response half faster.

the error log is found after adding the "--skip-name-resolve mode" parameter
1
2 120203 10:21:06 [Warning] ' user ' entry ' @jimmyli ' ignoredin--skip-name-resolve mode.
just go to the server inside the user [email protected] and @jimmyli Delete.
Tip warning Information:
1 130739 11:12:22 [Warning] ' user ' entry ' [email protected] ' ignoredin--skip-name-resolve mode.
2
in general, when optimizing the MySQL configuration parameters, add "--skip-name-resolve" and then check the startup log when restarting MySQL and find a warning message. Above

cause Analysis:
"--skip-name-resolve mode" is to disable DNS resolution, to avoid the network DNS resolution service to raise access to MySQL error, generally should be enabled.
when "--skip-name-resolve mode" is enabled, the hostname cannot be used in the MySQL authorization table, only IP is used, this warning occurs because the Localhost.localdomain account information already exists in the MySQL table.

Workaround:
The deletion of the warning account will be solved.
mysql command line:
1
2
3
4
5 Query OK, 2rowsaffected (0.00 sec)
Finally, restart MySQL, and then look at the error message prompt, the log found that the warning is gone. This method is warning when MySQL is enabled with Skip-name-resolve mode.

Optimizing MySQL when opening skip-name-resolve parameters

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.