Tuning mysql network performance debugging tools

This article describes network performance management techniques for Linux systems. It mainly describes how to use route, netstat, and tcpdump network management test tools and their functions.

Route

When configuring the network, you must specify the path through which the packet is received for the machine. In Linux, a command route is provided, which can be used to set a static route for the NIC configured by the ifconfig command. This setting is usually introduced in/etc/rc. d/rc. inet1 during system boot.

Here are several examples to illustrate how to use the route command:

Route add-net 127.0.0.0

This command adds a route entry with a specified address or network to the routing table. Note that the network is A Class A address, the mask is set to 255.0.0.0, and the newly added entry is connected to the lo device.

Route add-net xxx. xxx netmask limit 255.255.0 dev eth0

This command adds a route for the host whose IP address is xxx. xxx, and its network mask is set to 255.255.255.0.

Route del-net xxx. xxx

This command will delete the route of the network xxx. xxx.

The route command can also be used to conveniently manage the route information of the entire network. The output result is the route table of the network. As follows:

-----------------------------------------------------------------

[Root @ lee/root] # route

Kernel IP routing table

Destination Gateway Genmask Flags Metric Ref Use Iface

10.10.8.20.* 255.255.255.255 UH 0 0 0 eth0

10.10.8.0*255.255.255.0 U 0 0 0 eth0

127.0.0.0*255.0.0.0 U 0 0 0 lo

Default dgc8.njupt.edu 0.0.0.0 UG 0 0 0 eth0

Default dgc8.njupt.edu 0.0.0.0 UG 1 0 eth0

[Root @ lee/root] #

-----------------------------------------------------------------

The meaning of each field in the output result is:

· Destination indicates the Destination IP address of the route.

· Gateway indicates the host name or IP address used by the Gateway. The output "*" indicates no gateway.

· Genmask indicates the network mask of the route. Before comparing it with the target address of the route, the kernel uses Genmask and the IP address of the packet to perform the bitwise AND operation to set the route.

· Flags indicates a route entry. The available flag indicates that the route is starting. H indicates that the target is a host, G indicates that the gateway is used, R indicates that the dynamic route is reset. D indicates that the route is dynamically installed, M indicates modifying the route ,! Indicates that the route is denied.

· Metric indicates the sales volume of the route.

· Ref indicates the number of other routes that depend on the current status of the current route.

· Use indicates the number of route table entries used.

· Iface indicates the destination network of the packet sent by the route.

By viewing the output information, we can conveniently manage the route table of the network.

Netstat

The netstat command is a useful tool for monitoring TCP/IP networks. It displays the route table, the actual network connection, and the status information of each network interface device. After netstat is executed on a computer, the output result is as follows:

-----------------------------------------------------------------

[Root @ lee/root] # netstat

Active Internet connections (w/o servers)

Proto Recv-Q Send-Q Local Address Foreign Address State

Active UNIX domain sockets (w/o servers)

Proto RefCnt Flags Types State I-Node Path

For Unix 5 [] DGRAM 460/dev/log

Unix 0 [] stream connected 173 @ 00000014

Unix 0 [] DGRAM 662

Unix 0 [] DGRAM 631

Unix 0 [] DGRAM 544

Unix 0 [] DGRAM 484

Unix 0 [] DGRAM 470

[Root @ lee/root] #