webman用云數(shù)據(jù)庫經(jīng)過一輪并發(fā)強(qiáng)度1500后所有進(jìn)程處于busy狀態(tài)并且恢復(fù)的很慢用.本地數(shù)據(jù)庫就好點(diǎn)能到cpu差不多打滿

服務(wù)器 ：12核心 12g內(nèi)存 10m 帶寬
測試用例 ： 一個簡單的sql 查詢

云數(shù)據(jù)庫配置:serveless
數(shù)據(jù)庫類型 MySQL5.7
數(shù)據(jù)庫內(nèi)存 [1024 M - 16384 M]
CPU [0.5 - 8]

程序代碼 (此代碼和我thinkphpfpm 線上真實代碼一致)

<?php
namespace app\controller;

use support\Request;
use support\think\Db;
use support\Response;
class UserController
{
    public function hello(Request $request) : Response
    {
        $param = $request -> get();

        $lon = $param['longitude'];
        $lat = $param['latitude'];
        // var_dump($param);
        #更新位置
        // RealAddressService::real_address($lat , $lon);

        $keyword = $param['content'];
        if($param['sort'] == 1){
            $sort = 'dist asc';
        }
        if($param['sort'] == 2){
            $sort = 'fo.order desc';
        }
        if($param['sort'] == 3){
            $sort = 'sort asc';
        }

        $post = Db::table('data_factory_post')
            ->alias("fp")
            ->leftJoin("data_factory f", "f.id = fp.fid")
            ->leftJoin("factory_order fo", "fo.post_id = fp.id")
            ->field('fp.id,fp.target,fo.id as fo_id,fo.order,fp.name,fp.type,fp.price,fo.data,f.address')
            -> where('fo.status',1)
            ->where(function ($query) use ($keyword,$param) {
                if (!empty($keyword)) {
                    $query -> whereLike("fp.name|f.name|fp.price", "%{$keyword}%");
                }
                if($param['type'] == 1){
                    $query -> whereTime('fo.date', 'between', [date('Y-m-d'),date('Y-m-d')]);
                }
                if($param['type'] == 2){
                    $query -> whereTime('fo.date', 'between', [date('Y-m-d',strtotime('+1 day')),date('Y-m-d',strtotime('+1 day'))]);
                }
            })
            ->with([
                'factory' => function ($query) {
                    $query->where(['status' => 1, 'deleted' => 0])
                        -> field(["id", "name", "cover",'address' ,"settlement_type"]);
                }
            ])
            ->fieldRaw("(st_distance(point(longitude,latitude),point($lon,$lat))*111195)/1000 as dist")
            ->order($sort)
            ->paginate([
                'list_rows' => $param['limit'],
                'page' => $param['page'],
            ])
            ->toArray();

            foreach($post['data'] as $key => &$value){
                $value['target'] = array_filter(explode(',',  $value['target']));
                $as =  json_decode($value['data'],true);
                $rest['工價'] = '未知';
                if(!empty($as['工價'])) {
                    $rest['工價'] = $as['工價'];
                }
                $value['data'] = json_encode($rest);
            }
        // dump($post);
        return json([
            'code' => 0, 
            'msg' => 'ok', 
            'data' => $post
        ]);
    }
}

報錯信息

這里粘貼報錯

webman 配置截圖

php8.2
wenbman 2.1
event 擴(kuò)展已安裝
linux 優(yōu)化已做

單請求耗時

并發(fā)1500 進(jìn)程全busy 并且 恢復(fù)很慢

我用thinkphp fpm 同樣的 強(qiáng)度模擬 好無壓力 cpu 最高只占到 40 ，但是 fpm 單請求有180ms