- simply use the asynchronous mysql client of swoole to obtain 100000 data. After spending a long period of time in php7 in one environment, you can execute the callback method of query to output data, but in the php5.4 of another environment, you do not directly exit with any error, and there is no callback function that executes to query.
I guess it is the different configuration of PHP. The data of 10, 000 is fine, but I don"t know how to modify the configuration
$db->connect($server, function ($db, $r) {
$dbPreix = "m_";
if ($r === false) {
var_dump($db->connect_errno, $db->connect_error);
die;
}
//
$sql = "SELECT queue_id,group_id,content,data,keyword FROM ".$dbPreix."_queue ".
"WHERE 1=1 limit 100000";
$db->query($sql, function(swoole_mysql $db, $r) {
print_r($r);
});