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!?
Get your free @yahoo.com address at http://mail.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
