sql-server - Laravel:设置 MSSQL 超时

Question

我正在 Linux 上工作，并在不同的主机上使用 MSSQL 数据库，该数据库可能可用也可能不可用。是否可以为此设置合理的超时时间？例如。 2、3秒就足够了。目前，按照我的默认设置，超时时间超过 1 分钟。

连接设置:

    'mssql' => [
      'driver' => 'sqlsrv',
      'host' => 'CDBSQLSERVER',
      'database' => 'MyDatabase',
      'username' => 'XXXX',
      'password' => 'XXXX',
      'charset' => 'utf8',
      'prefix' => ''
    ]

freetds.conf

    [CDBSQLSERVER]
    host = 192.168.43.141
    port = 1433
    tds version = 7.0

我这样使用它:

$myDb = DB::connection('mssql');
$myDb->select(...);

Answer 1

尝试使用PDO::ATTR_TIMEOUT选项:

PDO::ATTR_TIMEOUT: Specifies the timeout duration in seconds. Not all drivers support this option, and its meaning may differ from driver to driver. For example, sqlite will wait for up to this time value before giving up on obtaining an writable lock, but other drivers may interpret this as a connect or a read timeout interval. Requires int.

http://php.net/manual/en/pdo.setattribute.php

在database.php中:

'mysql' => [
    'driver'    => 'mysql',
    'host'      => 'localhost',
    'database'  => 'database',
    'username'  => 'root',
    'password'  => '',
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix'    => '',
    'options'   => [
        PDO::ATTR_TIMEOUT => 1,
    ],
],