mysql数据库错误日志非常大

cncbm

mysql数据库错误日志非常大，6G多了，看了下里面全是这种信息，一直无限重复的在生成中，请问要怎么解决呢？2016-03-01 11:07:21 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:21 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:21 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:21 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:21 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:21 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.
2016-03-01 11:07:22 8445 [Warning] IP address 'X.X.X.X' has been resolved to the host name '1.5.1.rdns.xxx.com', which resembles IPv4-address itself.

licess

这个只是warning级别的不影响
/etc/my.cnf 里[mysqld]段里加上个skip-name-resolve 应该就不会再有这个提示了

cncbm

在/etc/my.cnf里具体要怎么写呢？这样直接加上吗？还是要有什么值？
[mysqld]
port        = 3306
socket      = /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 1024
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 64M
thread_cache_size = 128
query_cache_size = 128M
tmp_table_size = 128M
table_open_cache = 1024
skip-name-resolve

licess

可以