Hi,
Since I could not find any solution over internet (none of them helped) I must turn to other users if anyone has solution.
I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!
When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:\windows\system32\drivers\ets\hosts - but no luck.
2. I tried to edit C:\Program Files (x86)\Parallels\Plesk\MySQL\Data\my.ini - adding lines
bind-address=127.0.0.1
skip-name-resolve
then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
Has anyone of you found solution to this problem - I guess all usesr windows windows server 2012 has the same problem??!?!...
Thanks, Aris.
Since I could not find any solution over internet (none of them helped) I must turn to other users if anyone has solution.
I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!
When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:\windows\system32\drivers\ets\hosts - but no luck.
2. I tried to edit C:\Program Files (x86)\Parallels\Plesk\MySQL\Data\my.ini - adding lines
bind-address=127.0.0.1
skip-name-resolve
then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
Has anyone of you found solution to this problem - I guess all usesr windows windows server 2012 has the same problem??!?!...
Thanks, Aris.