If you have MySQL installed in Windows server and you are querying from Linux, you might notice that the performance of you application is very slow. This is because, when your application in Linux connects to database in Windows, even a simple query takes 3-4 seconds to execute.
The solution for this problem is to put a line 'skip-nam-resovle' in my.ini of your mysql server. Search for [mysqld] in my.ini and put that line below it as below.
[mysqld]
skip-name-resolve
No comments:
Post a Comment