MySQL on CentOS: localhost or 127.0.0.1 ?

[xtech]

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]

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]

I've just setup two boards, one with localhost and other with 127.0.0.1 in centOS. Let's see what happens!

[Makoto]

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.