Ezweni lika software free Kukhona zonke izinhlobo zezinhlelo zokusebenza, kusuka kokuncane kakhulu kuye kokusetjenziswa okwaziwa kakhulu nokwenziwa kwemikhuba, njenge I-GIMP, Apache o MySQL. Futhi njengoba sikhuluma ngenjini yedatha, sizobonisa ukuthi singaxazulula kanjani iphutha elingavela kwezinye izimo, futhi lokho I-MySQL: Ukuxhumeka okuningi kakhulu.
Sithi kungenzeka ngoba singachitha isikhathi esiningi sikusebenzisa lokho kungenzeki, noma ngokuzumayo kungenzeka ukuthi uma iseva yethu inesidingo esikhulu sizobona umlayezo wephutha kungekudala, okungaba okuqondile mysqli_connect (): (HY000 / 1040): Ukuxhumeka okuningi kakhulu.
Ngokuzenzakalelayo i-MySQL ivumela ubuningi bezicelo ezingenayo eziyi-100, okuthile okungabonakali kucace kakhulu emibhalweni yayo eningi ngakho-ke kungaba nzima ukuxazulula ezinye izinkinga kwesinye isikhathi. Okufanele sikwenze ukusebenzisa umhleli wethu owuthandayo ukuguqula ifayela lokumiswa lomphathi wedatha wamahhala, okuyi- /etc/my.cnf, futhi sizibeke ngezansi - noma esikhundleni ngaphakathi- kwesigaba [mysql]
Sengeza imigqa elandelayo:
ukuxhumana kwe-max_ = 500
max_user_connections = 500
Silondoloza ifayela bese siqala kabusha insiza:
i-systemctl qala kabusha i-mysqld.service
Manje yethu I-MySQL manje izokwazi ukwamukela ukuxhumana okungama-500 okungenayo ngasikhathi sinye, inombolo engaphezulu kokuhlonipheka ezimweni eziningi yize kunjalo kungokuphikisana ngokuphelele futhi singabeka noma iyiphi enye inombolo ngokwesidingo sethu sokukwazi ukuhambela izicelo eziningi futhi ngaleyo ndlela siphephe hhayi kuphela ekufuneni okukhulu kakhulu kepha nakunoma yiliphi iphutha ukuhlela okungaziwa (okuyisona sizathu esenza le nkinga ikhiqizwe).