Laravel Database Connection Pool Setup

To set up a database connection pool in Laravel, you can configure it in the config/database.php file. You can use the ‘options’ key in the ‘connections’ array to set up relevant options for the connection pool.

Below is an example of configuring a database connection pool.

'mysql' => [
    'driver' => 'mysql',
    'url' => env('DATABASE_URL'),
    'host' => env('DB_HOST', '127.0.0.1'),
    'port' => env('DB_PORT', '3306'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => '',
    'strict' => true,
    'engine' => null,
    'options' => [
        PDO::ATTR_PERSISTENT => true, // 开启持久化连接
        PDO::ATTR_EMULATE_PREPARES => true, // 开启预处理语句的模拟
        PDO::ATTR_STRINGIFY_FETCHES => false, // 禁用数据类型自动转换
    ],
],

In the example above, we have set some common database connection pool options in the options array. You can configure the connection pool options based on your own needs.

Please note that in order to make the connection pool work, you need to ensure that the pdo_mysql extension is installed and that persistent connections in PDO are enabled, as well as correctly configuring the database connection information.