How to resolve "Error log file size is increasing in mysql 5.5" issue w/o restarting mysql I have an Ubuntu server with MySQL 5.5 installed. In /var/lib/mysql a .err file is kept on updating with these warnings only:

[Warning] IP address '234.22.11.221' could not be resolved: Temporary failure in name resolution
[Warning] IP address '234.22.11.221' could not be resolved: Temporary failure in name resolution


Its size is currently around 2 GB.

I googled this error and in most of the places it has been written that I need to write skip-host-cache in my.cnf file and then need to give a restart mysql.

Currently this server is carrying lot of running web services, applications and giving a restart may effect all these applications.

As far as I understand, these warnings are not native mysql errors.

Also, can someone tell me whether these warnings effect my database in future if I will not take any action and is it possible that due to other web applications, these errors are generating? What is the other way around for this without restarting mysql?

IS there any probability , that mysql will not come up after restart ???
Put the following parameters in your my.cnf and then restart the service:-

skip-name-resolve
log-warnings=1


The above activity will solve your  issue.

Try to check this link also:-

https://serverfault.com/questions/341290/mysql-warning-ip-address-could-not-be-resolved