Hordhaca khaladka MySQL: Xidhiidh badan
Markaad haysato codsi websaydh ah (goob, baloog, gole, iwm) oo baahi weyn loo qabo, taas oo ah, in tiro badan oo isticmaaleyaal ahi soo booqdaan, tani waxay u tarjumaysaa adeegsiga macaamiisha oo kordhay Haddii la dhaho barnaamijka webka wuxuu adeegsadaa keydka MySQL iyo weydiimaha runtii way badan yihiin (barnaamij xumo awgeed ama adeegsadayaal badan oo isticmaalaya shabakadda), waxaa jirta suurtagalnimada in MySQL uu soo bandhigi doono qaladkan:
mysqli_connect(): (HY000/1040): Too many connections
Muxuu yahay MySQL: Khaladaadka isku xirnaanta badan
Waxay ka dhigan tahay in codsiyo aad u tiro badani imanayaan MySQL, in ka badan inta ay aqbali karto, in ka badan inta ay safka u geli karto ama sugi karto.
Sidee loo xaliyaa?
Fudud, waa inaan kordhinaa xadka ugu badan ee codsiyada (isku xirnaanta) ee MySQL ay taageerto.
Waxaan ku siin doonaa laba ikhtiyaar oo aad ku xalliso dhibaatadan:
1. Waxaan wax ka bedelnaa faylka /etc/mysql/my.cfg:
nano /etc/mysql/my.cfg
Dhexdeeda waxaan hoos dhigeynaa halka ay ku qoran tahay [mysql]:
max_connections = 500 max_user_connections = 500
Tani waxay kordhin doontaa tirada ugu badan ee isku xirnaanta laga bilaabo 100 (taas oo ah tan ugu dambeysa) illaa 500.
Waan keydinaa oo ka baxnaa, ka dib waxaan dib u bilaabi doonaa adeegga MySQL waana intaas. Isbeddelkani waa mid joogto ah.
2. Hab kale oo lagu xallin karo dhibaatadan waa in la beddelo xadka ugu sarreeya ee loo siman yahay, laakiin loo maro su'aasha MySQL.
Aynu marka hore tusno xadka hadda jira:
mysql --user="root" --password="PASSWORD" --execute='SHOW VARIABLES LIKE "max_connections";'
Tani waxay ina tusi doontaa wax sidan oo kale ah:
+ --------------------- + ------- + | Magaca bedbeddela | Qiimaha | + --------------------- + ------- + | max_connections | 151 | + ----------------- + ------- +
Si kale haddii loo dhigo, xadka hadda jira waa 151 isku xirnaanta, waa hagaag, aan kor ugu qaadno 500 iyadoo la adeegsanayo weydiin:
mysql --user="root" --password="PASSWORD" --execute='SET GLOBAL max_connections = 500;'
Diyaar u ah!
Dhibaatada qaabkan ayaa ah in markii adeegga dib loo bilaabo, qaabeyntaasi ay luntay.
Si aad faahfaahintan u samayso, waxaad samayn kartaa qoraal bash ah oo hubiya wakhti kasta oo X ah, ama xitaa ku dar khadka bilawga ama dib-u-bilawga daemon
Laakin markaa maxaan rabaa in aan ogaado doorashadan 2aad? … si fiican, taasi waa waxa aan idhi. Laakiin bil ka hor server Ubuntu wuu iska indho-tiray habka No.1, markaa ... xaaladaha aadka u daran ee OS nacas ah, waxaan haysanaa ikhtiyaarkan 2nd oo u shaqeeya sidoo kale
Qoraal wanaagsan, MySql… waxbadan ayey ku isticmaalaan FreeBSD,…. iyada oo loo marayo Webka), SFTP (Nidaamka Beddelka SSH-Faylasha), Apache - PHP- MySql, PHP5 iyo PhpSysInfo Extensions.
Tan awgeed waa inaan rakibo FreeBSD, uma maleynayo inaan hadda haysto waqtiga, kaliya waan bedelay shaqooyinka waxaana haystaa xilal badan oo cusub 🙁
Waxaan dhawaan lahaa inaan sameeyo wax la mid ah mashruuc leh nodejs. Kiiskeyga wuxuu u kordhay 250 taasna waa igu filneyd, hadda si fiican ayaan u socdaa. Waad ku mahadsantahay warbixinta
Waad salaaman tahay, ma i caawin kartaa sida loo galo /etc/mysql/my.cfg?
Waxaan haystaa VPS, laakiin kuma geli karo PUTTY.
Thanks.
Si loo xalliyo dhibaatada Xulashada 1. - Ikhtiyaarka la soo koobay, oo la ilaaliyo isbeddelada marka dib loo bilaabayo serverka, feylka waa in lagu saxaa iyadoo loo eegayo nooca:
/_______________________________ // /______________________________
// Beddel buuga Ubuntu 16.04 ///////
/_______________________________ // /______________________________
Waxaan arkay /etc/mysql/mysql.conf.d/mysqld.cnf
/_______________________________ // /______________________________
// Beddel buuga Ubuntu 15.04 ///////
/_______________________________ // /______________________________
vi /etc/mysql/mariadb.conf.d/mysqld.cnf
/_______________________________ // /______________________________
// Waxaan bedelay galka ku yaal Ubuntu duug / /
/_______________________________ // /______________________________
Waxaan arkay /etc/mysql/my.cnf
/_______________________________ // /______________________________
// kudar khadkan hoostiisa [mysqld] ama [mysql] tag //
// Kadib dib u bilaw server-ka //
/_______________________________ // /______________________________
max_connections = 500
Casharrada laga bilaabo xoqidda marna ma kuu sheegayo sida loo beddelo