Strange MySQL Performance Problem.

[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

[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.

[naveedanjum]

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

With Regards
Naveed

[mwasif]

Checkout MySQL Manual for detailed info.