The efficiency of php connecting to remote server mysql is too slow, how to solve it?

linux server, a master server, the speed of using
tp5 to connect to the website opened by mysql, is too slow, how to solve it?
skip_name_resolve
this part of the code has been added
clipboard.png

Linux mysql php thinkphp5
Sep.01,2021

depends on whether the link between your two servers is slow. If it's slow, there's nothing you can do about it. Or put the mysql on the web server, or change the server in the same computer room to do the mysql server.

Previous: What is the significance of one model per table in the PHP framework

Next: How does python extract the inner subtables of the excel table?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
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-1be9758-306c4.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-1be9758-306c4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?