Use mysql to remotely query data. the server is centos. The number of queried database tables exceeds 10. after the command is entered, the query will remain stuck and wait for 20 minutes. I encountered the same problem before. at that time, because the telecom network was logged on through the optical cat, it was resolved by the router login. Because it is a leased line network, there is no need to log on to a fixed IP address, and no virtual login is required. I don't know if this problem is caused by mysql or network blocking. Mysql server
Use mysql to remotely query data. the server is centos.
The number of queried database tables exceeds 10. after the command is entered, the query will remain stuck and wait for 20 minutes.
I encountered the same problem before. at that time, because the telecom network was logged on through the optical cat, it was resolved by the router login.
Because it is a leased line network, there is no need to log on to a fixed IP address, and no virtual login is required.
I don't know if this problem is caused by mysql or network blocking.