MySQL 1040 Too many connections

解决Too Many Connections错误

最新推荐文章于 2025-10-12 14:20:48 发布

原创最新推荐文章于 2025-10-12 14:20:48 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

本文记录了一次因数据库连接数过多导致的Too Many Connections错误排查过程。通过展示系统状态和服务运行情况，分析了PHP FastCGI进程管理及数据库连接配置，并提供了具体的变量设置详情。

部署运行你感兴趣的模型镜像

PDOException: SQLSTATE[08004] [1040] Too many connections in /home/fl/basic/vendor/yiisoft/yii2/db/Connection.php:630

MariaDB [tmp]> show variables like '%connection%';
+--------------------------+-----------------+
| Variable_name            | Value           |
+--------------------------+-----------------+
| character_set_connection | utf8            |
| collation_connection     | utf8_general_ci |
| extra_max_connections    | 1               |
| max_connections          | 214             |
| max_user_connections     | 0               |
+--------------------------+-----------------+
5 rows in set (0.01 sec)

MariaDB [tmp]>

[root@fl my.cnf.d]#systemctl status php-fpm
● php-fpm.service - The PHP FastCGI Process Manager
   Loaded: loaded (/usr/lib/systemd/system/php-fpm.service; enabled; vendor preset: disabled)
   Active: active (running) since Wed 2017-06-21 10:49:55 CST; 30min ago
 Main PID: 849 (php-fpm)
   Status: "Processes active: 3, idle: 27, Requests: 4409, slow: 0, Traffic: 3.2req/sec"
   CGroup: /system.slice/php-fpm.service
           ├─ 849 php-fpm: master process (/etc/php-fpm.conf)
           ├─1256 php-fpm: pool www
           ├─1257 php-fpm: pool www
           ├─1258 php-fpm: pool www
           ├─1259 php-fpm: pool www
           ├─1260 php-fpm: pool www
           ├─1261 php-fpm: pool www
           ├─1262 php-fpm: pool www
           ├─1263 php-fpm: pool www
           ├─1264 php-fpm: pool www
           ├─1265 php-fpm: pool www
           ├─1273 php-fpm: pool www
           ├─1288 php-fpm: pool www
           ├─1289 php-fpm: pool www
           ├─1350 php-fpm: pool www
           ├─1361 php-fpm: pool www
           ├─1396 php-fpm: pool www
           ├─1398 php-fpm: pool www
           ├─1409 php-fpm: pool www
           ├─1417 php-fpm: pool www
           ├─1448 php-fpm: pool www
           ├─1451 php-fpm: pool www
           ├─1465 php-fpm: pool www
           ├─1467 php-fpm: pool www
           ├─1468 php-fpm: pool www
           ├─1469 php-fpm: pool www
           ├─1471 php-fpm: pool www
           ├─1472 php-fpm: pool www
           ├─1477 php-fpm: pool www
           ├─1482 php-fpm: pool www
           └─1487 php-fpm: pool www

Jun 21 10:49:52 fl systemd[1]: Starting The PHP FastCGI Process Manager...
Jun 21 10:49:55 fl systemd[1]: Started The PHP FastCGI Process Manager.
[root@fl my.cnf.d]#