[Ithiphu] Iphutha lokuxhuma eliningi kakhulu le-MySQL, lixazululiwe

Le yinothi engqondweni yami, ngihlala ngixazulula amaphutha futhi kwesinye isikhathi kungithatha isikhashana kepha ngishaya umaki xD.

Isikhathi esithile, iPostfix + DOvecot + MySQL yawela ezandleni zami, yayinhle kakhulu naseDebian, esebenza kahle… Kepha benginephutha, isikhathi nesikhathi iPostfix ibizokhipha iphutha elinikeza lokhu okuthunyelwe isihloko.

Mina, ohlala ngiphenya, kwesinye isikhathi anginiki isikhathi noma ukuxhumana kwe-Intanethi [kuhamba kancane ngezikhathi ezithile], namuhla ngithole isisombululo futhi ngikwethulela sona.

IMysql inamanani wokuzenzakalelayo kwesinye isikhathi angawafuni nokuwafuna kuyo yonke i-Intanethi, namuhla ngemuva kokufunda okuncane [Ucwaningo lwe-FTW! xD], ngafika kumanani futhi ngakwazi ukuxazulula inkinga.

Ngakho-ke, yehlela ebhizinisini:
1- [nano, vi, mcedit] /etc/mysql/my.cnf
2- Sibheke isimemezelo se- [mysqld] futhi ngaphakathi sibhala:

max_connections = 500
max_user_connections = 500

3- Sigcina ukumiswa bese siqala kabusha i-MySQL.

/etc/init.d/mysql restart

5- Ukulungele!

Lawa manani avumelekile kunoma iyiphi insizakalo exhuma ngqo ku-MySQL, ithi i-PHP, i-Postfix, i-Dovecot, njll.

Lawa manani angashintshwa ngokuya ngezilungiselelo zawo ngamunye, ngoba uma unabasebenzisi abangama-30 kuphela akunangqondo ukubeka ama-500 ...

Okwanamuhla ngiyaqeda, kuze kufike ithiphu / iposi elandelayo bafana