[TOC] ## 安裝(默認已安裝) `composer require easyswoole/mysqli` ## 配置信息 在 `dev.php` 數組后添加配置信息 ``` 'MYSQL' => [ 'host' => '', 'port' => 3306, 'user' => '', 'password' => '', 'database' => '', 'timeout' => 30, 'charset' => 'utf8mb4', 'connect_timeout' => '5',//連接超時時間 ], ``` ## 設置線程池 ### 注冊mysql EasySwoole的全局initialize 事件中 ``` use EasySwoole\EasySwoole\Config as GConfig; use EasySwoole\MysqliPool\Mysql; use EasySwoole\Mysqli\Config; $configData = GConfig::getInstance()->getConf('MYSQL'); $config = new Config($configData); /** 這里注冊的名字叫mysql，你可以注冊多個，比如mysql2,mysql3 */ $poolConf = Mysql::getInstance()->register('mysql',$config); $mysql = Mysql::getInstance()->register('mysql1',$config); ``` ### 服務啟動后任意位置使用 ``` $db = \EasySwoole\MysqliPool\Mysql::getInstance()->pool('mysql')::defer(); var_dump($db->rawQuery('select version()')); $db = \EasySwoole\MysqliPool\Mysql::defer('mysql'); var_dump($db->rawQuery('select version()')); ``` ## 原生注冊 線程池 > [官網](https://www.easyswoole.com/Cn/Components/mysqlPool.html#mark-H2-14)