November 25, 2024, 11:42:55 AM

News : LinuxSolved.com Linux Help Community Forum..


Author Topic: How to disable host name lookup in mysql to increase performance  (Read 4698 times)

Offline Noob

  • Linux Noob !
  • *
  • Posts: 10
How to disable host name lookup in mysql to increase performance
« on: December 08, 2007, 01:49:44 PM »
Hi
someone told me that I need to disable hostname lookup for my company mysql server to reduce server response time
so please tell me how do I ?

Offline dragoncity99

  • LST CareTaker
  • Experienced
  • *****
  • Posts: 551
Re: How to disable host name lookup in mysql to increase performance
« Reply #1 on: December 26, 2007, 06:47:39 AM »
If you do not wish to use FQDN or hostnames to access your server (for example: mysql) you can just do so simply by using that server's IP address rather than the hostname.

There could be other factors that hit the server performance such as hardware and  OS tuning itself other than the misconfiguration of DNS itself. However, that is left to your hand as a sys admin to decide.