Technology sharing

한어Русский языкEnglishFrançaisIndonesianSanskrit日本語DeutschPortuguêsΕλληνικάespañolItalianoSuomalainenLatina

1. Nimis multi hospites

---

Ambitus operans: Winows11, Phpstudy V8.1.1.3, MySQL 5.7.26

Terminus est numero coniunctionum MySQL simul.

1. 1040 - Too many connections

Videre current maximus numerus hospites

1. mysql> show variables like '%max_connection%';
2. +-----------------+-------+
3. | Variable_name | Value |
4. +-----------------+-------+
5. | max_connections | 100 |
6. +-----------------+-------+

Mutare maximus nexus

1. set global max_connections=500;

2. MySQL servo abiit

---

Ambitus operans: Winows11 + Phpstudy V8.1.1.3

Post MySQL intrantes lineam mandati, si ministerium MySQL diu sine aliqua operatione operatum coniunges, MySQL ministerium sponte disiunget et sequens promptum apparebit cum iterum operationem perficies.

1. ERROR 2006 (HY000): MySQL server has gone away
2. No connection. Trying to reconnect...
3. Connection id: 2
4. Current database: liang

Reprehendo sicco duobus modis scribere timeout (per default timeout est 120 secundis);

1. select @@wait_timeout;
2. show variables like 'wait_timeout';

In current sessionis timeout est profectus ad DCC seconds

1. set @@wait_timeout = 700;