如何用hyperf操作mysql数据库

方法如下

1、安装包composer require hyperf/db-connection

2、修改配置文件.env和config/autoload/database.php中的数据库配置

3、添加路由

Router::get('/db', 'App\Controller\DbController@index');

4、添加controller

<?php declare(strict_types=1);
namespace App\Controller;
use Hyperf\HttpServer\Contract\RequestInterface;
use Hyperf\DbConnection\Db;
class DbController extends AbstractController
{
    public function index(RequestInterface $request)
    {
        $id = $request->input('id', 1);
        $list = Db::connection('default')->select("select *from user where id = $id");
        return $list;
    }
}

5、ab压力测试

[root@iZbp13ph356ra22ldly01lZ hyperf-skeleton]# ab -n 1000 -c 1000 http://118.31.251.197:9501/db?id=3
This is ApacheBench, Version 2.3 
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 118.31.251.197 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests


Server Software:        Hyperf
Server Hostname:        118.31.251.197
Server Port:            9501

Document Path:          /db?id=3
Document Length:        1280 bytes

Concurrency Level:      1000
Time taken for tests:   0.675 seconds
Complete requests:      1000
Failed requests:        0
Write errors:           0
Total transferred:      1425000 bytes
HTML transferred:       1280000 bytes
Requests per second:    1482.57 [#/sec] (mean)
Time per request:       674.504 [ms] (mean)
Time per request:       0.675 [ms] (mean, across all concurrent requests)
Transfer rate:          2063.15 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        2   49   3.4     50      54
Processing:    44  350 139.9    374     578
Waiting:        4  350 140.0    374     578
Total:         57  398 137.6    423     619

Percentage of the requests served within a certain time (ms)
  50%    423
  66%    475
  75%    508
  80%    530
  90%    582
  95%    598
  98%    612
  99%    616
 100%    619 (longest request)

发现确实效率很高

更多参考https://www.cnblogs.com/hu308830232/p/15338166.html

如有问题，可以QQ搜索群1028468525加入群聊，欢迎一起研究技术

有疑问联系站长，请联系QQ：