Why is the response time of connecting to the database on the same network segment different?

now there are three servers, one database server, two business servers An and B, and the three servers have the same network segment, but the time for A to connect to the database is fast (less than 1 second). But B is slow to connect to the database (about 10 seconds).

the length of tracking route is similar to that of ping:

A:

clipboard.png

B:

clipboard.png

ask the gods to help find out what the problem is.

Feb.25,2022

finally query to the database needs to disable DNS parsing, or write a hosts, access speed in the database server will be very fast

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1c2a9da-33a1f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1c2a9da-33a1f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?