Hello every one...
We are going into making the final changes to our production MySQL server. production server configuration is Free BSD PIII dual processor 800 mhz, 750 MB RAM. back_log = 20 DEFAULT back_log = 200 CHANGED flush_time = 1800 sec DEFAULT flush_time = 3600 sec CHANGED key_buffer_size = 16 MB DEFAULT key_buffer_size = 30 MB CHANGED max_allowed_packet = 10MB DEFAULT max_allowed_packet = 20MB CHANGED max_connections = 100 DEFAULT max_connections = 250 CHANGED Apache ,Tomcat, MySQL is running on the same machine.Kindly give us your expert opinion is it wise to run the three servers with the given server hardware configuration on the same machine...? Is it safe to alter the above mentioned server variables...? If safe..what is the syntax to set these parameters on Free BSD shell An example would be more help full. Thanx. Vijay Khanna System Analyst www.spsoftware.com Ph: 09120 - 4006154 INDIA ---------------------------------------------------------------------------- ------------------------------------------------ FOR THOSE WHO CAME LATE : 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. 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