Member Avatar for naveedanjum

I am facing a query performance problem. While connecting to MySQL database through different Users methodology.

Tell me does connecting by IP address user has over head.
Like

connecting using user@locahost or user@host-ip-address


Is there any performance-wise difference by connecting using any of this user.

I am getting a massive difference in performance by changing my db user to

user@localhost. i.e. few some milliseconds to < 2 sec

Where as the average response time using
user@host-ip-address is greater then 1 sec to less 6 sec


With Regards
Naveed

  • 2 Contributors
  • 3 Replies
  • 134 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for mwasif

If you are connecting from a remote machine when using IP address then to reduce the reverse name resolution overhead use skip-name-resolve in my.cnf/my.ini.

Member Avatar for naveedanjum

Thanks for replying but can you tell whats the effect of reverse name resolution? and How it works?

With Regards
Naveed

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.