Home / server / Questions / 659801
In Process
Codek
Asked: 2015-01-16 07:56:35 +0800 CST

Local MySQL connection using eth0 rather than lo loopback

  • 772

We've installed MySQL 5.6.22 on RHEL6.6 and noticed terrible performance compared to a previous install on RHEL6.5 and MySQL 5.6.20

The main thing that we've noticed is that all the traffic appears on eth0 rather than lo so we see output from SAR like so:

Average: IFACE rxpck/s txpck/s rxkB/s txkB/s rxcmp/s txcmp/s rxmcst/s Average: lo 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Average: eth0 2313.71 2.01 606.04 0.61 0.00 0.00 2311.37 Average: eth1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Average: eth2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Average: eth3 0.00 0.00 0.00 0.00 0.00 0.00 0.00

The connections are from the local box, and connecting to 127.0.0.1. Hosts file has an entry for this as usual, in fact all the networking seems to be setup the same as the old box.

And is this a red herring or would this definitely cause the problem? Presumably loopback is faster than a real physical interface?

networking

0 Answers