TP6 Think-Swoole RPC服务的高性能数据库访问优化策略

// config/database.php

return [
    ...
    // 数据库连接池配置
    'connections' => [
        'default' => [
            ...
            'pool' => [
                'max_connection' => 20,  // 连接池最大连接数
                'min_connection' => 10,  // 连接池最小连接数
                'wait_time' => 3,        // 连接池等待时间，单位：秒
                'max_idle_time' => 300,  // 连接的最大空闲时间，单位：秒
            ],
        ],
    ],
];

// app/rpc/service/DbPool.php

namespace apppcservice;

use thinkDb;
use thinkacadeDb as DbFacade;

class DbPool
{
    protected $pool;
    
    public function __construct()
    {
        $config = config('database.connections.default.pool');
        $this->pool = new SwooleCoroutineChannel($config['max_connection']);
        
        for ($i = 0; $i < $config['min_connection']; $i++) {
            $connection = $this->createConnection();
            $this->pool->push($connection);
        }
    }
    
    public function getConnection()
    {
        if ($this->pool->isEmpty()) {
            $connection = $this->createConnection();
        } else {
            $connection = $this->pool->pop();
        }
        
        return $connection;
    }
    
    public function releaseConnection($connection)
    {
        $this->pool->push($connection);
    }
    
    protected function createConnection()
    {
        DbFacade::setConfig(config('database.connections.default'));
        $connection = DbFacade::connect();
        
        return $connection;
    }
}

// app/rpc/service/UserService.php

namespace apppcservice;

class UserService
{
    public function getUser($id)
    {
        $dbPool = new DbPool();
        $connection = $dbPool->getConnection();
        
        $user = $connection->table('user')->find($id);
        
        $dbPool->releaseConnection($connection);
        
        return $user;
    }
}