Geek Answers Handbook

Database access speed by local IP address or loopback?

Question:

MySQL only accepts one IP address to listen on. So you can do bind-address = 127.0.0.1 or bind-address = 192.168.1.125

since 192.168.1.125 - this is the same computer as 127.0.0.1, it is assumed that you do not want to communicate with 0.0.0.0.

So, if I installed it in 192.168.1.125 in order to allow connection to it from another computer (for example, to administer a database, create tables, update, etc.), then the web application running on 192.168.1.125 also will have to connect through 192.168.1.125.

Now my question is: Will the database query performance from the web application on the computer 192.168.1.125 be worse if the application connects to IP 192.168.1.125, and not when it connects as 127.0.0.1?

Theoretically, he sent the request through the router back to himself, which would slow down performance, not the loopback interface.

Basically, is there enough driver / OS to understand that it should not send data over the network, because in this case it is not necessary?

+5
source share
2 answers
traceroute 192.168.1.125

on Linux, respectively

tracert 192.168.1.125

on windows should give you an answer :)

, , , , . , , .

+5

:

  • , , , .

. , . , .

, , , mysql, "bind-address". , , ( , , , , ).

0

More articles:


All Articles