如何通过 PHP PDO 使用异步 Mysql 查询

Mysqlnd 驱动程序 PHP 5.6 有机会使用异步查询http://php.net/manual/en/mysqli.reap-async-query.php http://php.net/manual/en/mysqli.reap-async-query.php

如何将异步查询与 PDO 结合使用？

这不行，代码（PHP 异步 mysql 查询 https://stackoverflow.com/questions/27240421/php-asynchronous-mysql-query):

$dbConnectionOne = new \PDO($cnn0, $conf['user'], $conf['pass']);
$dbConnectionOne->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);

$dbConnectionTwo =  new \PDO($cnn0, $conf['user'], $conf['pass']);
$dbConnectionTwo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$dbConnectionTwo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);


$t = time();
$synchStmt = $dbConnectionOne->prepare('SELECT sleep(2)');
$synchStmt->execute();

$asynchStmt = $dbConnectionTwo->prepare('SELECT sleep(1)');
$asynchStmt->execute();

$measurementConfiguration = array();
foreach ($synchStmt->fetchAll() as $synchStmtRow) {
   print_r($synchStmtRow);
}

while (($asynchStmtRow = $asynchStmt->fetch()) !== false) {
   print_r($asynchStmtRow);
}


$t = time() - $t;

echo 'query execute ', $t, ' sec',PHP_EOL;

排除 2 秒，但结果 = 3 秒

不可以。您不能将 Mysql 异步查询与 PDO 一起使用。 mysqli是唯一的选择。

你可以用这个mysqli_multi_query或常规的query/poll/reap http://php.net/manual/ru/mysqli.poll.php顺序。