xtech Posted November 11, 2015 Posted November 11, 2015 When installing IPS, should i select localhost or 127.0.0.1? I've seen that in linux, mySQL localhost uses a pipe to communicate instead of TCP/IP protocol and that it should be faster than 127.0.0.1. (In windows it seems that 127.0.0.1 is faster than localhost due to ip resolution) What is your experience with those values in CentOS or other linux distribution? Is there any noticeable speed difference?
MDPP Posted November 13, 2015 Posted November 13, 2015 In my experience, localhost tends to be slightly faster on Debian, but it's not a notable speed difference. I tend to just stick with localhost when using Linux.
xtech Posted November 13, 2015 Author Posted November 13, 2015 I've just setup two boards, one with localhost and other with 127.0.0.1 in centOS. Let's see what happens!
Makoto Posted January 5, 2016 Posted January 5, 2016 Unix sockets are inherently faster than communicating over TCP/IP. Using localhost on Linux tells MySQL to communicate using sockets, 127.0.0.1 uses TCP/IP. On Windows it makes no difference which you use. You should stick with localhost, but the difference is mostly negligible to answer your question.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.