cncbm 发表于 2016-3-1 21:38:53

mysql数据库错误日志非常大

mysql数据库错误日志非常大，6G多了，看了下里面全是这种信息，一直无限重复的在生成中，请问要怎么解决呢？2016-03-01 11:07:21 8445 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 发表于 2016-3-2 11:02:01

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

cncbm 发表于 2016-3-2 15:23:12

回复 2# 的帖子

在/etc/my.cnf里具体要怎么写呢？这样直接加上吗？还是要有什么值？

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 发表于 2016-3-2 20:08:42

回复 3# 的帖子

可以
页: [1]
查看完整版本: mysql数据库错误日志非常大