mysql 07001_mysql – 数据库连接限制是否应该等于连接的进程数？

在PostgreSQL(我不知道MySQL)中有

max_connections属性定义为：

Determines the maximum number of

concurrent connections to the database

server. The default is typically 100

connections, but might be less if your

kernel settings will not support it

(as determined during initdb). This

parameter can only be set at server

start.

Increasing this parameter might cause

PostgreSQL to request more System V

shared memory or semaphores than your

operating system’s default

configuration allows. See 07001 for information on how to adjust those parameters, if necessary.

客户端连接的有效限制定义为：

max_connections - superuser_reserved_connections

你需要采取一些透视图.今天让我们说40个max_connections对你来说是安全的,它可以保留一些操作系统资源(如documentation所述的semamphores和共享内存),但明天它可能还不够：

psql: FATAL: sorry, too many clients already

让我们计算你获得的利润&#x