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
