21,886
社区成员
发帖
与我相关
我的任务
分享
/usr/local/php/bin/php /data/sscf-manager/think queue:listen --queue AiSqlQueue --delay=0 --memory=128 --sleep=3 --tries=0 --timeout=300
ini_set("memory_limit", "512M");
ini_set("max_execution_time", "10");
if (!defined('MYSQLI_OPT_READ_TIMEOUT')) {
define ('MYSQL_OPT_WRITE_TIMEOUT', 10);
}
if (!defined('MYSQL_OPT_READ_TIMEOUT')) {
define ('MYSQL_OPT_READ_TIMEOUT', 10);
}
$mysqli = mysqli_init();
//$mysqli->options(MYSQLI_OPT_READ_TIMEOUT, 2);
$configDatabaseSource = config('db_config6');
$dbInfo = $configDatabaseSource['行情服务库'];
$mysqli->options(MYSQL_OPT_READ_TIMEOUT, 3);
$mysqli->options(MYSQL_OPT_WRITE_TIMEOUT, 1);
$mysqli->real_connect($dbInfo['hostname'], $dbInfo['username'], $dbInfo['password'], $dbInfo['database'], $dbInfo['hostport']);
if ($mysqli->connect_errno) {
throw new Exception('数据库连接失败!');
}
$mysqli->set_charset('utf8');
$result = $mysqli->query($sql);
$res = mysqli_fetch_all($result, 1);