Ungalilungisa kanjani iphutha le-MySQL: Ukuxhumeka okuningi kakhulu

Alejandro (a.k.a KZKG^Gaara)

Imizuzu ye-2

Isingeniso sephutha le-MySQL: Ukuxhumeka okuningi kakhulu

Uma unohlelo lokusebenza lwewebhu (isayithi, ibhulogi, iforamu, njll.) Okufuneka kakhulu, okungukuthi, ukuthi inani elikhulu labasebenzisi liyavakasha, lokhu kuguqulela ekusetshenzisweni okwandisiwe kuseva. Uma uhlelo lokusebenza lewebhu lisebenzisa i-database ye-MySQL futhi imibuzo miningi impela (ngenxa yohlelo olubi lwewebhu noma abasebenzisi abaningi abasebenzisa iwebhu), kungenzeka ukuthi i-MySQL ikhombise leli phutha:

mysqli_connect(): (HY000/1040): Too many connections

Kusho ukuthini i-MySQL: Iphutha lokuxhumeka okuningi kakhulu lisho ukuthini?

Kusho ukuthi izicelo eziningi kakhulu ziyeza ku-MySQL, ezingaphezu kwalokho ezingakwemukela, ngaphezu kokuma emgqeni noma ukulinda.

Ungayixazulula kanjani?

Kulula, kufanele sikhuphule umkhawulo omkhulu wezicelo (ukuxhumana) osekelwa yi-MySQL.

Ngizokunikeza izinketho ezimbili zokulungisa le nkinga:

1. Sihlela ifayela /etc/mysql/my.cfg:

nano /etc/mysql/my.cfg

Kuyo sifaka okulandelayo ngaphansi lapho ithi [mysql]:

max_connections = 500 max_user_connections = 500

Lokhu kuzokhuphula inani eliphezulu lokuxhuma lisuke ku-100 (okungokuzenzakalelayo) liye ku-500.

Songa futhi siphume, bese siqala kabusha insiza ye-MySQL futhi yilokho kuphela. Lolu shintsho lungunaphakade.

2. Enye indlela yokuxazulula le nkinga ukuguqula umkhawulo omkhulu ulingana, kepha ngombuzo we-MySQL.

Ake siqale sibonise umkhawulo wamanje:

mysql --user="root" --password="PASSWORD" --execute='SHOW VARIABLES LIKE "max_connections";'

Lokhu kuzosikhombisa into enjengale:

+ ----------------- + ------- + | Igama_liguqukayo | Inani | + ----------------- + ------- + | ukuxhumana kwe-max | 151 | + ----------------- + ------- +

Ngamanye amagama, umkhawulo wamanje ukuxhumeka okungu-151, ake sikukhuphulele ku-500 ngombuzo:

mysql --user="root" --password="PASSWORD" --execute='SET GLOBAL max_connections = 500;'

Silungile!

Inkinga ngale ndlela ukuthi lapho insiza iqalwa kabusha, lokhu kulungiselelwa kulahlekile.

Ukunikezela le mininingwane, ungenza iskripthi se-bash esiqinisekisa ngaso sonke isikhathi se-X, noma ungeze ulayini ekuqaleni noma ekuqaleni kabusha ibhulokhi yedayimoni 😉

Kepha-ke kungani ngifuna ukwazi le nketho yesi-2? ... kahle, yilokho ebengikusho njalo. Kepha enyangeni edlule indlela ye-Ubuntu Server enganakwa No.1, ngakho ... ezimweni ezimbi kakhulu ze-silly OS, sinenketho yesi-2 esebenza kahle nje 😉


Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.

  1.   NEX kusho
    kwenza iminyaka 9

    Okuthunyelwe okuhle, i-MySql… basebenzisa okuningi ku-FreeBSD,… .KZKG ^ Gaara?,… Kungakuhle uma ubhala, ukuthi ungayifaka kanjani futhi uyilungiselele kanjani i-MySql ku-FreeBSD njenge: SSH (safe - shell), SSH (ngeWebhu), SFTP (I-SSH-File Transfer Protocol), i-Apache - PHP- MySql, i-PHP5 ne-PhpSysInfo Extensions.

    Phendula ku-nex
    1.    KZKG ^ Gaara kusho
      kwenza iminyaka 9

      Ngalokhu kuzofanele ngifake i-FreeBSD, angicabangi ukuthi nginesikhathi njengamanje, ngivele ngashintsha imisebenzi futhi nginezibopho eziningi ezintsha 🙁

      Phendula ku-KZKG ^ Gaara
  2.   uSawule kusho
    kwenza iminyaka 9

    Muva nje bekumele ngenze into efanayo ngephrojekthi enama-nodejs. Endabeni yami lakhuphukela ku-250 futhi lokho kwakwanele, manje ngenza kahle. Siyabonga ngolwazi

    Phendula uSawule
  3.   Francisco kusho
    kwenza iminyaka 8

    Sawubona, ungangisiza ukuthi ngingene kanjani /etc/mysql/my.cfg?

    Ngine-VPS, kepha angikwazi ukungena noPUTTY.

    Ukubingelela

    Phendula uFrancisco
  4.   isiheho kusho
    kwenza iminyaka 7

    Ukuxazulula inkinga ye-Option 1.- Inketho ebekiwe, futhi ugcine izinguquko lapho uqala kabusha iseva, ifayela kufanele lihlelwe ngokuya ngenguqulo:

    //////////////////////////////////////////////////////////////// //////////////////////
    // Ngiguqula umkhombandlela ku-Ubuntu 16.04 ///////////////////////////
    //////////////////////////////////////////////////////////////// //////////////////////
    VI /ETC/MYSQL/MYSQL.CONF.D/MYSQLD.CNF.

    //////////////////////////////////////////////////////////////// //////////////////////
    // Ngiguqula umkhombandlela ku-Ubuntu 15.04 ///////////////////////////
    //////////////////////////////////////////////////////////////// //////////////////////
    vi /etc/mysql/mariadb.conf.d/mysqld.cnf.

    //////////////////////////////////////////////////////////////// //////////////////////
    // Ngiguqula umkhombandlela ku-Ubuntu old ///////////////////////////
    //////////////////////////////////////////////////////////////// //////////////////////

    VI /etc/mysql/my.cnf.

    //////////////////////////////////////////////////////////////// //////////////////////
    // engeza lo mugqa ngaphansi kwe- [mysqld] noma i- [mysql] tag //
    // Bese uqala kabusha iseva //
    //////////////////////////////////////////////////////////////// //////////////////////
    ukuxhumana kwe-max_ = 500

    Phendula ku-carnaza
  5.   ethukuthele kusho
    kwenza iminyaka 6

    Okokufundisa kusuka ekuqaleni akunakukutshela ukuthi ungakushintsha kanjani

    Phendula ngolaka