yen ngetikmu bener kaya iki: ? set-variable = max_connections=250 set-variable = max_connec_errors=10000 <-- saya tambahkan ini perintah iki: SHOW VARIABLES LIKE 'max_connect_errors'; ora bakal hasile 1000,
kecualin perintahmu ngene: SHOW VARIABLES LIKE 'max_connec_errors'; apa sebabe? max_connec_errors=10000 ning ' connec' kurang 't', yen iku salah ketik lo.. mysql_save iku ora ana... saelingku anake iku.. mysqld_save .... cek 'd' ning 'mysql' .. On 6/22/06, sandy suryadinata <[EMAIL PROTECTED]> wrote: > > beberapa kali sering saya dapat error > "Too many connection errors", Unblock with 'mysqladmin flush-hosts'. > baca2 sih utk mencegah terjadi eror tsb kita kudu set > max_connect_errors = 10000 (defaultnya 10) > > nah gmn nambahinnya? saya coba set file di /etc/my.cnf > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > set-variable = max_connections=250 > set-variable = max_connec_errors=10000 <-- saya tambahkan ini > > tapi saya cek > >SHOW VARIABLES LIKE 'max_connect_errors'; > +-------------------+----+ > |max_connect_errors | 10 | > +-------------------+----+ > > nah? apa harus saya restart mysql nya? masalahnya kalo saya restart > sekarang (peak hours) bakal banyak yg komplein ntar.. > > -- > Best Regards, > > > Sandy Suryadinata > -------------------------------------------- > Department of UTI (Unit Teknologi Informasi) > 2nd Floor, J - Building, > Malangkucecwara School of Economics > Phone : +62 341 491813 - Ext. 125, 127 > http://www.stie-mce.ac.id > -------------------------------------------- > blog + http://sandynata.wordpress.com > > > > [Non-text portions of this message have been removed] > > > > > ================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY > <================ > Posting : [email protected] > Archive : http://www.mail-archive.com/[email protected]/ > www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id > > ************************************************************************************ > Yahoo! Groups Links > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/x3XolB/TM --------------------------------------------------------------------~-> ================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY <================ Posting : [email protected] Archive : http://www.mail-archive.com/[email protected]/ www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id ************************************************************************************ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/mitek/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
