At 21:48 22/02/02 -0800, vijay khanna wrote: Hi! >Hiya forum.. > >I have my site powered by MySQL server running on >FreeBSD. >The site is facing problems when the traffic >increases.Database connectivity is through JDBC.My >poolman is managing the >database connections with 30 connections set, and is >growable.People have started getting error when the >rush increases... > >Error : Communication failure : Bad Handshake. > Is there a MySQL server running on the port >............ > connectivity error. > >I suspect the max_connection variable which is default >set to 100 reaches and the server refuses further >connection.We have probed for any unused database >connections hold by the Java.But we have religiously >returned the connection back to the poolmanager after >its used... > >I am running my development MySQL server on windows >NT. Having gone thru the MySQL manual..for performance >tuning the server,we came across many variables which >can affect the server performance. > >So i issue the following commands: > >c:\> cd mysql\bin > >start the server c:\>mysqld >set the variable c:\>mysqld -O back_log=200 --help > >Looks like it updates the server..but when i see it >thru the WinMySQLAdmin ,after restarting the server >again ,it does not reflect there and displays the >default settings. >
Set the max_connection variable on \windir\my.ini file for a number greater than 100. If you are using WinMySQLAdmin for to start the server, press the button for to stop the server extended status, that is for the tool not to query the server in the interval specified. We have suspect that this should arise a deadlock. Regards, Miguel >We have a production server running....Can any >experienced people guide me how to update this server >variable onto my remote server. > >Thanx. > >Vijay Khanna >System Analyst >www.spsoftware.com >Ph: 09120 - 4006154 >INDIA > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Sports - Coverage of the 2002 Olympic Games >http://sports.yahoo.com > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
