Why does my server mysql show a high proportion of CPU? after changing it to a remote database, the mysql process of the server of the remote database does not occupy CPU? at all

this is a very strange question. Because the original server often peak time 502, and then watch top because mysql occupies a very high CPU resources, and then want to make the database remote so that the load separation bar.

now that the database is remote, the original server during the peak period is still very high. From the top point of view, there are many php-fpm processes, of which one php-fpm accounts for a relatively high proportion of
cpu.

what"s strange is that the remote database server has almost no load at all.


, the situation is much better after enabling opcache


because of php-fpm, it is estimated that php-fpm is requesting a large number of MySql.
take a look at php-fpm 's request for MySql and the MySql server.

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-1e413b7-44938.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-1e413b7-44938.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?