How to configure the database connection pool in thinkphp

1. What is a database connection pool?

Traditional database connection is a way of exclusive resources. Each connection needs to consume system resources. If there are many concurrent users, then it will This leads to problems such as waste of system resources and response delays. The database connection pool is a method of connection sharing that caches connections into the connection pool. Multiple threads can share connections in the same connection pool, thereby reducing the consumption of system resources.

2. How to configure the database connection pool in thinkphp

1. Add the following content to the application configuration file

return [
    //数据库配置信息
    'database' => [
        // 数据库类型
        'type'            => 'mysql',
        // 服务器地址
        'hostname'        => '127.0.0.1',
        // 数据库名
        'database'        => 'test',
        // 用户名
        'username'        => 'root',
        // 密码
        'password'        => '',
        // 端口
        'hostport'        => '',
        // 数据库连接参数
        'params'          => [
            // 数据库连接池配置
            \think\helper\Arr::except(\Swoole\Coroutine::getContext(),'__timer'),
        ],
        // 数据库编码默认采用utf8
        'charset'         => 'utf8',
        // 数据库表前缀
        'prefix'          => 'think_',
    ],
];

2. Add the following content to the entry file index.php

use think\App;
use think\facade\Config;
use think\facade\Db;
use think\swoole\Server;
use think\swoole\websocket\socketio\Handler;
use think\swoole\websocket\Websocket;
use think\swoole\websocket\socketio\Packet;
use think\swoole\coroutine\Context;
use Swoole\Database\PDOPool;
use Swoole\Coroutine\Scheduler;

//定义应用目录
define('APP_PATH', __DIR__ . '/app/');

// 加载框架引导文件
require __DIR__ . '/thinkphp/vendor/autoload.php';
require __DIR__ . '/thinkphp/bootstrap.php';

// 扩展Loader注册到自动加载
\think\Loader::addNamespace('swoole', __DIR__ . '/thinkphp/library/swoole/');

// 初始化应用
App::getInstance()->initialize();

//获取数据库配置信息
$dbConfig = Config::get('database');

//创建数据库连接池
$pool = new PDOPool($dbConfig['type'], $dbConfig);

//设置连接池的参数
$options = [
    'min' => 5,
    'max' => 100,
];

$pool->setOptions($options);

//连接池单例模式
Context::set('pool', $pool);

//启动Swoole server
$http = (new Server())->http('0.0.0.0', 9501)->set([
    'enable_static_handler' => true,
    'document_root' => '/data/wwwroot/default/public/static',
    'worker_num' => 2,
    'task_worker_num' => 2,
    'daemonize' => false,
    'pid_file' => __DIR__.'/swoole.pid'
]);

$http->on('WorkerStart', function (swoole_server $server, int $worker_id) {

    //功能实现

});

$http->start();

The function of the above code is to build a PDOPool connection pool and set its minimum number of connections to 5 and its maximum number of connections to 100. Use Context to store connection pools in memory for use by extended thinkphp applications.

3. How to use the connection pool

In the process of using the connection pool, you need to pay attention to the following points:

1. Single case of the connection pool mode, different functions use the same connection pool object to ensure the consistency of the connection pool parameters.

2. Do not close MySQL immediately after performing the database operation, but return it directly to the connection pool. Because the connection is actually put back into the connection pool, not closed.

3. Don't think of the connection pool as an "immortal body", it also needs to be released. The method to release the connection pool is: $pool->close().

The following is an example of using connection pooling:

<?php namespace app\index\controller;

use think\Controller;
use Swoole\Database\PDOPool;

class Index extends Controller
{
    public function index()
    {
        //获取连接池
        $pool = \Swoole\Coroutine::getContext(&#39;pool&#39;);
        
        //从连接池中取出一个连接
        $connection = $pool->getConnection();
        
        //执行操作
        $result = $connection->query('SELECT * FROM `user`');
        
        //归还连接给连接池
        $pool->putConnection($connection);
        
        //返回结果
        return json($result);
    }
}

The above is the detailed content of How to configure the database connection pool in thinkphp. For more information, please follow other related articles on the PHP Chinese website!