都是用Db:table 查詢運(yùn)行一段時(shí)候后查詢報(bào)錯(cuò)Too many connections ,加了幾個(gè)定時(shí)任務(wù),cpu32個(gè)進(jìn)程128個(gè),改了這個(gè)進(jìn)程數(shù)還是會(huì)出現(xiàn)Too many connections這種情況服務(wù)器提示499
都是的用很簡(jiǎn)單的 Db:table 查詢 orm操作
[2023-06-10 10:26:33] default.ERROR: 10.2.5.7 GET 10.2.5.7:8787
PDOException: SQLSTATE[HY000] [1040] Too many connections in /www/wwwroot/qkl/vendor/illuminate/database/Connectors/Connector.php:70
Stack trace:
#0 /www/wwwroot/qkl/vendor/illuminate/database/Connectors/Connector.php(70): PDO->__construct()
#1 /www/wwwroot/qkl/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection()
#2 /www/wwwroot/qkl/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#3 /www/wwwroot/qkl/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#5 /www/wwwroot/qkl/vendor/illuminate/database/Connection.php(1064): call_user_func()
#6 /www/wwwroot/qkl/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
#7 /www/wwwroot/qkl/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
#8 /www/wwwroot/qkl/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect()
#9 /www/wwwroot/qkl/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#10 /www/wwwroot/qkl/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#11 /www/wwwroot/qkl/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#12 /www/wwwroot/qkl/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#13 /www/wwwroot/qkl/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#14 /www/wwwroot/qkl/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#15 /www/wwwroot/qkl/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#16 /www/wwwroot/qkl/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#17 /www/wwwroot/qkl/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#18 /www/wwwroot/qkl/vendor/illuminate/database/Concerns/BuildsQueries.php(294): Illuminate\Database\Eloquent\Builder->get()
#19 /www/wwwroot/qkl/app/controller/IndexController.php(43): Illuminate\Database\Eloquent\Builder->first()
#20 /www/wwwroot/qkl/vendor/workerman/webman-framework/src/App.php(319): app\controller\IndexController->index()
#21 /www/wwwroot/qkl/vendor/workerman/webman-framework/src/App.php(168): Webman\App::Webman\{closure}()
#22 /www/wwwroot/qkl/vendor/workerman/workerman/Connection/TcpConnection.php(646): Webman\App->onMessage()
#23 [internal function]: Workerman\Connection\TcpConnection->baseRead()
#24 /www/wwwroot/qkl/vendor/workerman/workerman/Events/Event.php(193): EventBase->loop()
#25 /www/wwwroot/qkl/vendor/workerman/workerman/Worker.php(1629): Workerman\Events\Event->loop()
#26 /www/wwwroot/qkl/vendor/workerman/workerman/Worker.php(1423): Workerman\Worker::forkOneWorkerForLinux()
#27 /www/wwwroot/qkl/vendor/workerman/workerman/Worker.php(1397): Workerman\Worker::forkWorkersForLinux()
#28 /www/wwwroot/qkl/vendor/workerman/workerman/Worker.php(1779): Workerman\Worker::forkWorkers()
#29 /www/wwwroot/qkl/vendor/workerman/workerman/Worker.php(1715): Workerman\Worker::monitorWorkersForLinux()
#30 /www/wwwroot/qkl/vendor/workerman/workerman/Worker.php(562): Workerman\Worker::monitorWorkers()
#31 /www/wwwroot/qkl/vendor/workerman/webman-framework/src/support/App.php(131): Workerman\Worker::runAll()
#32 /www/wwwroot/qkl/start.php(4): support\App::run()
#33 {main}
這里粘貼截圖
webman最新版本1.4
一個(gè)進(jìn)程一個(gè)mysql連接,你128個(gè)進(jìn)程,再加上計(jì)劃任務(wù)里的連接,會(huì)更多。mysql默認(rèn)連接限制100.超過(guò)就會(huì)報(bào)這個(gè)錯(cuò)誤。
先去mysql里看看設(shè)置的最大連接數(shù)。