Gabatarwa game da kuskuren MySQL: Hanyoyi da yawa
Lokacin da kake da aikace-aikacen yanar gizo (site, blog, forum, da dai sauransu) waɗanda ke cikin buƙata, ma'ana, adadi mai yawa na masu amfani suna ziyarta, wannan yana fassara zuwa yawan amfani akan sabar. Idan akace aikace-aikacen yanar gizo suna amfani da bayanan MySQL kuma tambayoyin suna da yawa da gaske (saboda mummunan shirye-shiryen yanar gizo ko kuma yawancin masu amfani da yanar gizo), akwai yiwuwar MySQL zai nuna wannan kuskuren:
mysqli_connect(): (HY000/1040): Too many connections
Me ake nufi da MySQL?
Yana nufin cewa buƙatu da yawa suna zuwa MySQL, fiye da yadda zata iya karɓa, fiye da yadda zata iya layi ko jira.
Yadda za a warware shi?
Mai sauƙi, dole ne mu ƙara iyakar iyakar buƙatun (haɗi) waɗanda MySQL ke tallafawa.
Zan ba ku zaɓuɓɓuka biyu don gyara wannan matsalar:
1. Muna shirya fayil /etc/mysql/my.cfg:
nano /etc/mysql/my.cfg
A ciki mun sanya abubuwa masu zuwa ƙarƙashin inda aka ce [mysql]:
max_connections = 500 max_user_connections = 500
Wannan zai ƙara yawan adadin haɗin haɗi daga 100 (wanda shine tsoho) zuwa 500.
Mun adana kuma mun fita, sannan zamu sake fara aikin MySQL kuma hakane. Wannan canjin ya dore.
2. Wata hanyar warware wannan matsalar ita ce canza matsakaicin iyaka, amma ta hanyar tambayar MySQL.
Bari mu fara nuna iyakar yanzu:
mysql --user="root" --password="PASSWORD" --execute='SHOW VARIABLES LIKE "max_connections";'
Wannan zai nuna mana wani abu kamar haka:
+ ---------------- + ------- + | Suna mai canzawa | Darajar | + ---------------- + ------- + | max_haɗi | 151 | + ----------------- + ------- +
Watau, iyakan yanzu shine haɗin 151, da kyau, bari mu ɗaga zuwa 500 ta hanyar tambaya:
mysql --user="root" --password="PASSWORD" --execute='SET GLOBAL max_connections = 500;'
Shirya!
Matsalar ta wannan hanyar ita ce lokacin da aka sake farawa da sabis, wannan tsarin ya ɓace.
Don samar da wannan daki-daki zaka iya yin rubutun bash wanda kowane lokacin X yake tabbatarwa, ko ma ƙara layin zuwa farawa ko sake farawa gunkin daemon 😉
Amma to me yasa nake son sanin wannan zaɓi na 2? ... da kyau, abin da nake faɗi kenan. Amma wata daya da ya gabata Ubuntu Server ya yi biris da hanyar No.1, don haka ... a cikin mawuyacin yanayi na wauta OS, muna da wannan zaɓi na 2 ɗin da ke aiki daidai 😉
Kyakkyawan matsayi, MySql… suna amfani da yawa a cikin FreeBSD,…. (Yarjejeniyar Canja wurin Fayil na SSH), Apache - PHP- MySql, PHP5 da PhpSysInfo Fadada.
Don yin wannan ya zama dole in girka FreeBSD, bana tsammanin ina da lokaci a yanzu, kawai na canza ayyuka ne kuma ina da sabbin ayyuka da yawa many
Kwanan nan ne nayi wani abu makamancin wannan don aikin tare da nodejs. A halin da nake ciki ya karu zuwa 250 kuma hakan ya isa, a yanzu ina aiki lafiya. Godiya ga bayanin
Barka dai, za ku iya taimaka min yadda ake shiga /etc/mysql/my.cfg?
Ina da VPS, amma ba zan iya shiga tare da PUTTY ba.
Na gode.
Don magance matsalar Option 1. - Zaɓin mentedaƙa, kuma kiyaye canje-canje lokacin sake farawa uwar garken, dole ne a gyara fayil ɗin bisa ga sigar:
/______________________________ /////////,
// Na canza kundin adireshi a cikin Ubuntu 16.04 ////////
/______________________________ /////////,
Na ga /etc/mysql/mysql.conf.d/mysqld.cnf
/______________________________ /////////,
// Na canza kundin adireshi a cikin Ubuntu 15.04 ////////
/______________________________ /////////,
vi /etc/mysql/mariadb.conf.d/mysqld.cnf
/______________________________ /////////,
// Na canza kundin adireshi a cikin Ubuntu tsoho ////////////////////
/______________________________ /////////,
Na ga /etc/mysql/my.cnf
/______________________________ /////////,
// ƙara wannan layin ƙarƙashin alamar [mysqld] ko [mysql] tag //
// To sake kunna sabar //
/______________________________ /////////,
max_connections = 500
Koyawa daga fashewa babu wani lokaci yana gaya muku yadda ake canza shi