MySQL Tuning Paramaters During Eval
Hi,
We are evaluating OpManager, DeviceExpert and Applications Manager.
Currently we have all three running on the box, but taking off Application Manager to a seperate server today.
The server we have is a Dell Power Edge 6850
4 x 3.8Ghz Dual Core
32 Gigabytes RAM
Redhat Linux Server AS 5.5 64 Bit
System Drive where the /, /etc, /usr etc are installed is a Mirror Raid on 10K RPM SCSCI3 Disks
Data Partition where the application is instaleld is under "/data1/appza/productname" is a RAID1 with 15K RPM SCSI3 Disks
The OpManager seems REALLLLLLY slow and device expert is doing "so so ". Device expert is running the database that came with the software. For OpManager here is the setup:
/data1/appz/OpManager/conf/database_params.conf
--
# url is of the form jdbc:subprotocol:DataSourceName for eg.jdbc:odbc:WebNmsDB
url jdbc:mysql://localhost:3306/OpManagerDB?dontTrackOpenResources=true AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# driver name
drivername org.gjt.mm.mysql.Driver AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# login username for database if any
username root AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# login password for the database if any
#password public AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# Number of transactional connections. (This number has to be zero for transaction disable mode).
TRANS_CONNECTIONS 0
# Number of non-transactional connections.
NON_TRANS_CONNECTIONS 10
#database name
databasename MYSQL
------------------------------------------
[root@neolog02 OpManager]# cat conf/wrapper.conf
# $Id: wrapper.conf,v 1.1.4.17 2006/07/12 07:46:38 ssharavanan Exp $
#********************************************************************
# Wrapper Properties
#********************************************************************
# Java Application
wrapper.java.command=jre\bin\java
# Java Main class. This class must implement the WrapperListener interface
# or guarantee that the WrapperManager class is initialized. Helper
# classes are provided to do this for you. See the Integration section
# of the documentation for details.
wrapper.java.mainclass=org.tanukisoftware.wrapper.WrapperSimpleApp
# Java Classpath (include wrapper.jar) Add class path elements as
# needed starting from 1
# Java Library Path (location of Wrapper.DLL or libwrapper.so)
wrapper.java.library.path.1=lib/
# Java Additional Parameters
wrapper.java.additional.1=-Dcatalina.home=tomcat
wrapper.java.additional.2=-Dmysql.home=mysql
#wrapper.java.additional.3=-Dwebserver.port=80
#wrapper.java.additional.4=-Dresource_check="80,8009"
wrapper.java.additional.3=-Djava.library.path=lib
wrapper.java.additional.4=-Dwebserver.rootdir=tomcat
wrapper.java.additional.5=-Djava.rmi.server.codebase=tomcat/conf/workers.properties
wrapper.java.additional.6=-Dcom.adventnet.me.opmanager.showprogress=true
wrapper.java.additional.7=-Dcom.adventnet.me.opmanager.service=true
# Initial Java Heap Size (in MB)
wrapper.java.initmemory=256
# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=4096
# Application parameters. Add parameters as needed starting from 1
wrapper.app.parameter.1=com.adventnet.me.opmanager.server.StartOpManagerJdbc
#wrapper.app.parameter.2=APACHE_DIR
#wrapper.app.parameter.3=./apache
# *** Do not change the paramenter 4 and 5 without touching opmanager_string_replaceInfo.xml ***
#wrapper.app.parameter.4=WEBSERVER_PORT
#wrapper.app.parameter.5=80
#wrapper.app.parameter.6=WEBCONTAINER_PORT
#wrapper.app.parameter.7=8009
wrapper.app.parameter.2=TOMCAT_DIR
wrapper.app.parameter.3=./tomcat/
#wrapper.app.parameter.10=NMS_BE_PORT
#wrapper.app.parameter.11=2000
wrapper.app.parameter.4=ROOT_DIR
wrapper.app.parameter.5=.
wrapper.app.parameter.6=NATIVE_PING
wrapper.app.parameter.7=true
wrapper.app.parameter.8=NMS_BE_FAILOVER
wrapper.app.parameter.9=true
wrapper.app.parameter.10=SERVICE
wrapper.app.parameter.11=true
#********************************************************************
# Wrapper Logging Properties
#********************************************************************
# Format of output for the console. (See docs for formats)
wrapper.console.format=PM
# Log Level for console output. (See docs for log levels)
wrapper.console.loglevel=NONE
# Log file to use for wrapper output logging.
wrapper.logfile=logs/wrapper.log
# Format of output for the log file. (See docs for formats)
wrapper.logfile.format=LPTM
# Log Level for log file output. (See docs for log levels)
wrapper.logfile.loglevel=INFO
# Maximum size that the log file will be allowed to grow to before
# the log is rolled. Size is specified in bytes. The default value
# of 0, disables log rolling. May abbreviate with the 'k' (kb) or
# 'm' (mb) suffix. For example: 10m = 10 megabytes.
wrapper.logfile.maxsize=10m
# Maximum number of rolled log files which will be allowed before old
# files are deleted. The default value of 0 implies no limit.
wrapper.logfile.maxfiles=1
# Log Level for sevent log output. (See docs for log levels)
wrapper.syslog.loglevel=FATAL
#********************************************************************
# Wrapper NT Service Properties
#********************************************************************
# WARNING - Do not modify any of these properties when an application
# using this configuration file has been installed as a service.
# Please uninstall the service before modifying this section. The
# service can then be reinstalled.
# Name of the service
wrapper.ntservice.name=OpManager
# Display name of the service
wrapper.ntservice.displayname=ManageEngine OpManager
# Description of the service
wrapper.ntservice.description=Network Monitoring Software
# Mode in which the service is installed. AUTO_START or DEMAND_START
wrapper.ntservice.starttype=AUTO_START
# Allow the service to interact with the desktop.
wrapper.ntservice.interactive=true
# Add debug
wrapper.debug=false
# Timeout used by the WrapperManager after asking the jvm to shutdown.
wrapper.jvm_exit.timeout=3000
# Restart counter.
wrapper.max_failed_invocations=2
# Interval to poll the jvm by wrapper.
wrapper.ping.interval=2995
# Timeout whiel polling the jvm by wrapper.
wrapper.ping.timeout=3000
# Thread dump will be printed when jvm failed to exit properly.
wrapper.request_thread_dump_on_failed_jvm_exit=TRUE
wrapper.cpu.timeout=2995
wrapper.startup.timeout=3000
wrapper.shutdown.timeout=3000
# Wrapper classpath
# Wrapper classpath
wrapper.java.classpath.1=classes/
wrapper.java.classpath.2=classes/OpManagerServerClasses.jar
wrapper.java.classpath.3=classes/OpManagerImages.jar
wrapper.java.classpath.4=classes/AdventNetLogging.jar
wrapper.java.classpath.5=classes/OpManagerCharts.jar
wrapper.java.classpath.6=classes/OpManagerBeans.jar
wrapper.java.classpath.7=classes/NmsServerClasses.jar
wrapper.java.classpath.8=classes/OpManagerClientClasses.jar
wrapper.java.classpath.9=classes/AdventNetSnmp.jar
wrapper.java.classpath.10=classes/AdventNetSAS.jar
wrapper.java.classpath.11=classes/crimson.jar
wrapper.java.classpath.12=classes/Mail.jar
wrapper.java.classpath.13=classes/activation.jar
wrapper.java.classpath.14=classes/AdventNetNPrevalent.jar
wrapper.java.classpath.15=classes/ManagementServer.jar
wrapper.java.classpath.16=classes/ManagementClient.jar
wrapper.java.classpath.17=tomcat/lib/servlet-api.jar
wrapper.java.classpath.18=tomcat/bin/bootstrap.jar
wrapper.java.classpath.19=mysql/mmmysqlDriver/mysql_connector.jar
wrapper.java.classpath.20=classes/AdventNetUI.jar
wrapper.java.classpath.21=classes/AdventNetUtils.jar
wrapper.java.classpath.22=classes/ApiUtils.jar
wrapper.java.classpath.23=classes/AdventNetCLI.jar
wrapper.java.classpath.24=classes/AdventNetJta.jar
wrapper.java.classpath.25=classes/AdventNetCLIClient.jar
wrapper.java.classpath.26=classes/jta.jar
wrapper.java.classpath.27=classes/JimiProClasses.zip
wrapper.java.classpath.28=classes/AdventNetTftp.jar
wrapper.java.classpath.29=classes/ftp.jar
wrapper.java.classpath.30=classes/jfreechart.jar
wrapper.java.classpath.31=classes/jgraph.jar
wrapper.java.classpath.32=classes/jcommon.jar
wrapper.java.classpath.33=tomcat/lib/commons-beanutils.jar
wrapper.java.classpath.34=tomcat/lib/commons-collections.jar
wrapper.java.classpath.35=tomcat/lib/commons-logging-api.jar
wrapper.java.classpath.36=tomcat/lib/commons-logging.jar
wrapper.java.classpath.37=classes/htmllexer.jar
wrapper.java.classpath.38=classes/htmlparser.jar
wrapper.java.classpath.39=classes/HTTPClient.jar
wrapper.java.classpath.40=classes/jasperreports/itext-1.01.jar
wrapper.java.classpath.41=classes/jasperreports/poi-2.0-final-20040126.jar
wrapper.java.classpath.42=classes/jasperreports/jasperreports-0.5.2.jar
wrapper.java.classpath.43=classes/RMECommon.jar
wrapper.java.classpath.44=classes/wrapper.jar
wrapper.java.classpath.45=classes/trayicon.jar
wrapper.java.classpath.46=classes/OpManagerStartupClasses.jar
wrapper.java.classpath.47=classes/AdventNetPersistence.jar
wrapper.java.classpath.48=classes/AdventNetPersistenceSA.jar
wrapper.java.classpath.49=classes/AdventNetRssLibrary.jar
wrapper.java.classpath.50=classes/commons-codec-1.3.jar
wrapper.java.classpath.51=classes/commons-httpclient-3.0-rc1.jar
wrapper.java.classpath.52=classes/jtds-1.0.3.jar
wrapper.java.classpath.53=classes/SMSServer.jar
wrapper.java.classpath.54=classes/SMSLib.jar
wrapper.java.classpath.55=classes/cryptix-jce-provider.jar
wrapper.java.classpath.56=classes/WiFiMediation.jar
wrapper.java.classpath.57=classes/OpManagerOperations.jar
wrapper.java.classpath.58=classes/axis.jar
wrapper.java.classpath.59=classes/commons-discovery.jar
wrapper.java.classpath.60=classes/commons-discovery-0.2.jar
wrapper.java.classpath.61=classes/saaj.jar
wrapper.java.classpath.62=classes/wsdl4j-1.5.1.jar
wrapper.java.classpath.63=classes/jaxrpc.jar
wrapper.java.classpath.64=classes/poi-3.0.1-FINAL-20070705.jar
wrapper.java.classpath.65=classes/iTextAsian.jar
wrapper.java.additional.8=-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
wrapper.java.additional.9=-Djava.util.logging.config.file=tomcat/conf/logging.properties
wrapper.java.additional.10=-XX:PermSize=64m
wrapper.java.additional.11=-XX:MaxPermSize=128m
wrapper.java.classpath.66=tomcat/lib/jasper.jar
wrapper.java.classpath.67=tomcat/lib/jsp-api.jar
wrapper.java.classpath.68=tomcat/bin/tomcat-juli.jar
wrapper.java.classpath.69=tomcat/lib/tomcat-dbcp.jar
wrapper.java.classpath.70=tomcat/lib/el-api.jar
wrapper.java.classpath.71=tomcat/lib/annotations-api.jar
wrapper.java.classpath.72=tomcat/lib/jasper-jdt.jar
wrapper.java.classpath.73=tomcat/lib/jasper-el.jar
wrapper.java.classpath.74=tomcat/lib/catalina-tribes.jar
wrapper.java.classpath.75=tomcat/lib/catalina.jar
wrapper.java.classpath.76=tomcat/lib/tomcat-coyote.jar
wrapper.java.classpath.77=tomcat/lib/catalina-ha.jar
wrapper.java.classpath.78=tomcat/lib/commons-digester.jar
wrapper.java.classpath.79=tomcat/lib/commons-fileupload-1.1.1.jar
wrapper.java.classpath.80=tomcat/lib/commons-io-1.2.jar
wrapper.java.classpath.81=classes/json.jar
wrapper.java.classpath.82=classes/vijava220090625.jar
wrapper.java.classpath.83=classes/dom4j-1.6.1.jar
wrapper.java.classpath.84=classes/jaxb-api.jar
wrapper.java.classpath.85=classes/jaxb-impl.jar
wrapper.java.classpath.86=classes/prefuse.jar
--------------------------------
ShutdownOpManagerServer and the startup scripts:
[root@neolog02 OpManager]# cat bin/ShutDownOpManager.sh
#!/bin/sh
#$Id: ShutDownOpManager.sh,v 1.7.4.1 2005/07/11 08:51:37 roshini Exp $
# This file can be used to ShutDown the Nms Server. It can be used from remote
# machine also. Just copy the ShutDown.class, BASE64Encoder.class and this file # to remote machine.
cd ..
. ./setEnv.sh
if [ $# -eq 2 ]
then
USER_NAME=$1
USER_PASSWD=$2
else
USER_NAME=root
fi
HOSTNAME=localhost
CLASSPATH=$NMS_CLASSES:$NMS_CLASSES/OpManagerStartupClasses.jar:$NMS_CLASSES/NmsServerClasses.jar:$NMS_CLASSES/ApiUtils.jar
export CLASSPATH
if [ $# -eq 0 ]
then
$JAVA_HOME/bin/java com.adventnet.me.opmanager.tray.ShutDownUI -HOST_NAME $HOSTNAME -USER_NAME $USER_NAME -NMS_RESOURCE_DIRECTORY $NMS_HOME/html -RESOURCE_PROPERTIES ShutDownNmsServerResources -RESOURCE_LOCALE en_US
else if [ $# -ne 2 ]
then
echo Invalid Usage
echo Usage : sh ShutDown \<username\> \<password\>
else
# Usage : java com.adventnet.nms.util.StandAloneShutDown \[-h host\] \[-u username\] \[-p password\]
$JAVA_HOME/bin/java com.adventnet.nms.util.StandAloneShutDown -h $HOSTNAME -u $USER_NAME -p $USER_PASSWD
fi
fi
[root@neolog02 OpManager]# cat bin/StartOpManagerServer.sh
#$Id: StartOpManagerServer.sh,v 1.23.4.8.4.9.4.4.2.1.6.5 2010/06/02 12:39:41 rravikumar Exp $
#echo on
# Checking whether the user is root user or not.
ID=`id | awk '{print $1}' | cut -d "=" -f2 | cut -d "(" -f1`
if [ ${ID} -ne 0 ]
then
echo "You must be a root user to start the OpManager server."
echo "Please login as root user and start the server again."
exit 1
fi
AWT_HEADLESS=
# Checking whether DISPLAY variable set the system or not.
if [ "$DISPLAY" = "" ]; then
AWT_HEADLESS=-Djava.awt.headless=true
fi
# Starting the OpManager server.
cd ..
CLASSPATH=
export CLASSPATH
. ./setEnv.sh
echo "Java Home " $JAVA_HOME
export LD_LIBRARY_PATH
#Please do not edit this entry, it will be used by the DeploymentWizard tool
CUSTOMPATH=
#Please do not remove/edit this entry, it will be used by the MOWizard tool
MOPATH=
SSL_CHK=
### The following lines are removed as apache is removed and only tomcat is used. The operation corrsponding to apache is commented below.
#if [ $WEBSERVER_HOME/ssl/backup/ssl.conf ]
#then
#cp -f $WEBSERVER_HOME/ssl/backup/ssl.conf $WEBSERVER_HOME/ssl
#SSL_CHK=$WEBSERVER_HOME/ssl/ssl.conf
#fi
#cp -f $WEBSERVER_HOME/conf/backup/httpd.conf $WEBSERVER_HOME/conf
cp -f $TOMCAT_HOME/conf/backup/server.xml $TOMCAT_HOME/conf
cp -f $TOMCAT_HOME/conf/backup/workers.properties $TOMCAT_HOME/conf
#cp -f $TOMCAT_HOME/conf/backup/mod_jk.conf-auto $TOMCAT_HOME/conf/mod_jk.conf-nms
#cp -f $WEBSERVER_HOME/bin/backup/* $WEBSERVER_HOME/bin
#CLASSPATH variable is changed to CLASS_PATH . If the classpath is set by using #the CLASSPATH variable ,RMI will load the classes from the CLASSPATH and not fr#om the codebase.
# LICENSE_PATH variable is to locate AdventNetLicense.ali directory path.
CLASS_PATH=$NMS_CLASSES:$NMS_CLASSES/WiFiMediation.jar:$NMS_CLASSES/jaxb-api.jar:$NMS_CLASSES/jaxb-impl.jar:$NMS_CLASSES/dom4j-1.6.1.jar:$NMS_CLASSES/vijava220090625.jar:$NMS_CLASSES/SMSServer.jar:$NMS_CLASSES/SMSLib.jar:$NMS_CLASSES/cryptix-jce-provider.jar:$NMS_CLASSES/OpManagerServerClasses.jar:$NMS_CLASSES/OpManagerCharts.jar:$NMS_CLASSES/OpManagerBeans.jar:$NMS_CLASSES/AdventNetLogging.jar:$NMS_CLASSES/OpManagerClientClasses.jar:$NMS_CLASSES/NmsServerClasses.jar:$NMS_CLASSES/RMECommon.jar:$NMS_CLASSES/AdventNetPersistence.jar:$NMS_CLASSES/AdventNetPersistenceSA.jar:$NMS_CLASSES/OpManagerStartupClasses.jar:$SUM_CLIENT_CLASSPATH:$SUM_SERVER_CLASSPATH:$CUSTOMPATH:$SNMP_CLASSPATH:$SAS_CLASSPATH:$XML_CLASSPATH:$OTHER_CLASSPATH:$MS_CLASSPATH:$WEBSERVER_CLASSPATH:$DB_CLASSPATH:$JAVA_CLASSPATH:$BUILDER_CLASSPATH:$TFTP_CLASSPATH:$CLI_CLASSPATH:$TRANSACTION_CLASSPATH:$NMS_CLASSES/AdventNetSnmpDistributedAPI.jar:$JIMI_CLASSPATH:$MOPATH:$LICENSE_PATH:$FTP_CLASSPATH:$JGRAPH_CLASSPATH:$JFREE_CHARTS_CLASSPATH:$JASPER_CLASSPATH:$HTTP_CLIENT_CLASSPATH:$RSS_CLASSPATH:$NMS_CLASSES/j2ssh-common.jar:$NMS_CLASSES/j2ssh-core.jar:$NMS_CLASSES/OpManagerOperations.jar:$NMS_CLASSES/axis.jar:$NMS_CLASSES/commons-discovery.jar:$NMS_CLASSES/commons-discovery-0.2.jar:$NMS_CLASSES/saaj.jar:$NMS_CLASSES/wsdl4j-1.5.1.jar:$NMS_CLASSES/jaxrpc.jar:$NMS_CLASSES/poi-3.0.1-FINAL-20070705.jar:$NMS_CLASSES/json.jar:$NMS_CLASSES/prefuse.jar
# Uncomment the following lines for using TL1 Protocol.
CLASS_PATH=$CLASS_PATH:$TL1_CLASSPATH
# Uncomment the following lines for using JMX Agent.
CLASS_PATH=$CLASS_PATH:$JMX_AGENT_CLASSPATH
JAVA_OPTS="-Dwebserver.rootdir=$WEBSERVER_HOME -Dwebnms.rootdir=$NMS_HOME -Dwebcontainer.home=$TOMCAT_HOME -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=$TOMCAT_HOME/conf/logging.properties"
#As apache is removed, passing of apache related files as arguments is removed.
$JAVA_HOME/bin/java -cp $CLASS_PATH $AWT_HEADLESS $JAVA_OPTS com.adventnet.me.opmanager.server.OpManagerInitWebSvr $TOMCAT_HOME/conf/server.xml $TOMCAT_HOME/conf/workers.properties
# Usage: java com.adventnet.nms.startnms.NmsMainBE [NATIVE_PING true/false] [BE_FE TCP/RMI] [NMS_BE_PORT back_end_port_num] [COUNTRY country_code] [LANGUAGE language_code] [SERVICE true/false] [USERS_DIR userDir] [ROOT_DIR rootDir]
if [ $? != 0 ]
then
exit 1
fi
#if [ ! -f $NMS_HOME/conf/startup.txt ]
#then
# $JAVA_HOME/bin/java -cp $NMS_CLASSES:$NMS_CLASSES/OpManagerStartupClasses.jar:$NMS_CLASSES/NmsClientClasses.jar:$NMS_CLASSES/OpManagerClientClasses.jar:$NMS_CLASSES/ApiUtils.jar:$NMS_CLASSES/OpManagerBeans.jar:$NMS_CLASSES/AdventNetUtils.jar:$NMS_CLASSES/GenVarPanel.jar:$NMS_CLASSES/JimiProClasses.zip:$NMS_CLASSES/AdventNetSnmp.jar:$NMS_CLASSES/AdventNetProBeans.jar:$NMS_CLASSES/AdventNetDMPModels.jar:$NMS_CLASSES/OpManagerImages.jar:$NMS_CLASSES/OpManagerServerClasses.jar:$OTHER_CLASSPATH:$NMS_CLASSES/NmsServerClasses.jar com.adventnet.me.opmanager.tray.DiscoveryWizard
# touch $NMS_HOME/conf/startup.txt
#fi
while(true)
do
$JAVA_HOME/bin/java -cp $CLASS_PATH $AWT_HEADLESS $JAVA_OPTS -Dcatalina.home=$TOMCAT_HOME -Dmysql.home=$MYSQL_HOME -Djava.rmi.server.codebase="$CODEBASE_LIST" -Xms512m -Xmx1024m -XX:PermSize=1024m -XX:MaxPermSize=1024m com.adventnet.me.opmanager.server.OpManagerMainBE ROOT_DIR $NMS_HOME NMS_BE_FAILOVER true $*
if [ $? -eq 126 -o -f Patch/smarttmp.txt ]; then
$JAVA_HOME/bin/java -cp $UPDATE_MANAGER_CLASSPATH com.adventnet.tools.update.installer.UpdateManager -u conf -h $NMS_HOME -c
if [ $? -ne 0 ]; then
exit
fi
else
exit;
fi
done
[root@neolog02 OpManager]#
------------------------------------
[root@neolog02 OpManager]# mysqld --version
mysqld Ver 5.0.46-enterprise-gpl-log for redhat-linux-gnu on x86_64 (MySQL Enterprise Server (GPL))
-----------------------
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
low_priority_updates=1
concurrent_insert=2
skip-external-locking
#skip-ndbcluster
#skipbdb
key_buffer_size = 400M
bulk_insert_buffer_size=50M
max_allowed_packet = 16M
table_cache = 2048
sort_buffer_size = 10M
read_buffer_size = 10M
read_rnd_buffer_size = 10M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
myisam_max_sort_file_size=50M
query_cache_size = 200M
query_cache_limit = 10M
thread_concurrency = 8
join_buffer_size=10M
#skip-networking
tmp_table_size=200M
max_heap_table_size=200M
log-bin=mysql-bin
expire_logs_days=15
server-id = 1
#log-bin=mysql-bin
tmpdir = /data1/appz/mysql/tmp
#log-update = /path-to-dedicated-directory/hostname
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 384M
#bdb_max_lock = 100000
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 400M
innodb_additional_mem_pool_size = 128M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
innodb_log_buffer_size = 10M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[root@neolog02 OpManager]#
-------------
Can you suggest some tuning paramaters to help speed this box up for the eval? There is nothing else this box will do except for recieve syslogs form all devices (3000+ network devices) so that OpManager can do alerts, run OpManager for 300-400 network devices, and Device Expert (that eval is doing after this one.).
So our Systems guys said that we should ask about tuning not only MYSQL, but also about tuning the .SH scritps we have, and definately tuning the TOMCAT/APACHE.
Would appreciate any help.
We are evaluating OpManager, DeviceExpert and Applications Manager.
Currently we have all three running on the box, but taking off Application Manager to a seperate server today.
The server we have is a Dell Power Edge 6850
4 x 3.8Ghz Dual Core
32 Gigabytes RAM
Redhat Linux Server AS 5.5 64 Bit
System Drive where the /, /etc, /usr etc are installed is a Mirror Raid on 10K RPM SCSCI3 Disks
Data Partition where the application is instaleld is under "/data1/appza/productname" is a RAID1 with 15K RPM SCSI3 Disks
The OpManager seems REALLLLLLY slow and device expert is doing "so so ". Device expert is running the database that came with the software. For OpManager here is the setup:
/data1/appz/OpManager/conf/database_params.conf
--
# url is of the form jdbc:subprotocol:DataSourceName for eg.jdbc:odbc:WebNmsDB
url jdbc:mysql://localhost:3306/OpManagerDB?dontTrackOpenResources=true AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# driver name
drivername org.gjt.mm.mysql.Driver AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# login username for database if any
username root AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# login password for the database if any
#password public AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# Number of transactional connections. (This number has to be zero for transaction disable mode).
TRANS_CONNECTIONS 0
# Number of non-transactional connections.
NON_TRANS_CONNECTIONS 10
#database name
databasename MYSQL
------------------------------------------
[root@neolog02 OpManager]# cat conf/wrapper.conf
# $Id: wrapper.conf,v 1.1.4.17 2006/07/12 07:46:38 ssharavanan Exp $
#********************************************************************
# Wrapper Properties
#********************************************************************
# Java Application
wrapper.java.command=jre\bin\java
# Java Main class. This class must implement the WrapperListener interface
# or guarantee that the WrapperManager class is initialized. Helper
# classes are provided to do this for you. See the Integration section
# of the documentation for details.
wrapper.java.mainclass=org.tanukisoftware.wrapper.WrapperSimpleApp
# Java Classpath (include wrapper.jar) Add class path elements as
# needed starting from 1
# Java Library Path (location of Wrapper.DLL or libwrapper.so)
wrapper.java.library.path.1=lib/
# Java Additional Parameters
wrapper.java.additional.1=-Dcatalina.home=tomcat
wrapper.java.additional.2=-Dmysql.home=mysql
#wrapper.java.additional.3=-Dwebserver.port=80
#wrapper.java.additional.4=-Dresource_check="80,8009"
wrapper.java.additional.3=-Djava.library.path=lib
wrapper.java.additional.4=-Dwebserver.rootdir=tomcat
wrapper.java.additional.5=-Djava.rmi.server.codebase=tomcat/conf/workers.properties
wrapper.java.additional.6=-Dcom.adventnet.me.opmanager.showprogress=true
wrapper.java.additional.7=-Dcom.adventnet.me.opmanager.service=true
# Initial Java Heap Size (in MB)
wrapper.java.initmemory=256
# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=4096
# Application parameters. Add parameters as needed starting from 1
wrapper.app.parameter.1=com.adventnet.me.opmanager.server.StartOpManagerJdbc
#wrapper.app.parameter.2=APACHE_DIR
#wrapper.app.parameter.3=./apache
# *** Do not change the paramenter 4 and 5 without touching opmanager_string_replaceInfo.xml ***
#wrapper.app.parameter.4=WEBSERVER_PORT
#wrapper.app.parameter.5=80
#wrapper.app.parameter.6=WEBCONTAINER_PORT
#wrapper.app.parameter.7=8009
wrapper.app.parameter.2=TOMCAT_DIR
wrapper.app.parameter.3=./tomcat/
#wrapper.app.parameter.10=NMS_BE_PORT
#wrapper.app.parameter.11=2000
wrapper.app.parameter.4=ROOT_DIR
wrapper.app.parameter.5=.
wrapper.app.parameter.6=NATIVE_PING
wrapper.app.parameter.7=true
wrapper.app.parameter.8=NMS_BE_FAILOVER
wrapper.app.parameter.9=true
wrapper.app.parameter.10=SERVICE
wrapper.app.parameter.11=true
#********************************************************************
# Wrapper Logging Properties
#********************************************************************
# Format of output for the console. (See docs for formats)
wrapper.console.format=PM
# Log Level for console output. (See docs for log levels)
wrapper.console.loglevel=NONE
# Log file to use for wrapper output logging.
wrapper.logfile=logs/wrapper.log
# Format of output for the log file. (See docs for formats)
wrapper.logfile.format=LPTM
# Log Level for log file output. (See docs for log levels)
wrapper.logfile.loglevel=INFO
# Maximum size that the log file will be allowed to grow to before
# the log is rolled. Size is specified in bytes. The default value
# of 0, disables log rolling. May abbreviate with the 'k' (kb) or
# 'm' (mb) suffix. For example: 10m = 10 megabytes.
wrapper.logfile.maxsize=10m
# Maximum number of rolled log files which will be allowed before old
# files are deleted. The default value of 0 implies no limit.
wrapper.logfile.maxfiles=1
# Log Level for sevent log output. (See docs for log levels)
wrapper.syslog.loglevel=FATAL
#********************************************************************
# Wrapper NT Service Properties
#********************************************************************
# WARNING - Do not modify any of these properties when an application
# using this configuration file has been installed as a service.
# Please uninstall the service before modifying this section. The
# service can then be reinstalled.
# Name of the service
wrapper.ntservice.name=OpManager
# Display name of the service
wrapper.ntservice.displayname=ManageEngine OpManager
# Description of the service
wrapper.ntservice.description=Network Monitoring Software
# Mode in which the service is installed. AUTO_START or DEMAND_START
wrapper.ntservice.starttype=AUTO_START
# Allow the service to interact with the desktop.
wrapper.ntservice.interactive=true
# Add debug
wrapper.debug=false
# Timeout used by the WrapperManager after asking the jvm to shutdown.
wrapper.jvm_exit.timeout=3000
# Restart counter.
wrapper.max_failed_invocations=2
# Interval to poll the jvm by wrapper.
wrapper.ping.interval=2995
# Timeout whiel polling the jvm by wrapper.
wrapper.ping.timeout=3000
# Thread dump will be printed when jvm failed to exit properly.
wrapper.request_thread_dump_on_failed_jvm_exit=TRUE
wrapper.cpu.timeout=2995
wrapper.startup.timeout=3000
wrapper.shutdown.timeout=3000
# Wrapper classpath
# Wrapper classpath
wrapper.java.classpath.1=classes/
wrapper.java.classpath.2=classes/OpManagerServerClasses.jar
wrapper.java.classpath.3=classes/OpManagerImages.jar
wrapper.java.classpath.4=classes/AdventNetLogging.jar
wrapper.java.classpath.5=classes/OpManagerCharts.jar
wrapper.java.classpath.6=classes/OpManagerBeans.jar
wrapper.java.classpath.7=classes/NmsServerClasses.jar
wrapper.java.classpath.8=classes/OpManagerClientClasses.jar
wrapper.java.classpath.9=classes/AdventNetSnmp.jar
wrapper.java.classpath.10=classes/AdventNetSAS.jar
wrapper.java.classpath.11=classes/crimson.jar
wrapper.java.classpath.12=classes/Mail.jar
wrapper.java.classpath.13=classes/activation.jar
wrapper.java.classpath.14=classes/AdventNetNPrevalent.jar
wrapper.java.classpath.15=classes/ManagementServer.jar
wrapper.java.classpath.16=classes/ManagementClient.jar
wrapper.java.classpath.17=tomcat/lib/servlet-api.jar
wrapper.java.classpath.18=tomcat/bin/bootstrap.jar
wrapper.java.classpath.19=mysql/mmmysqlDriver/mysql_connector.jar
wrapper.java.classpath.20=classes/AdventNetUI.jar
wrapper.java.classpath.21=classes/AdventNetUtils.jar
wrapper.java.classpath.22=classes/ApiUtils.jar
wrapper.java.classpath.23=classes/AdventNetCLI.jar
wrapper.java.classpath.24=classes/AdventNetJta.jar
wrapper.java.classpath.25=classes/AdventNetCLIClient.jar
wrapper.java.classpath.26=classes/jta.jar
wrapper.java.classpath.27=classes/JimiProClasses.zip
wrapper.java.classpath.28=classes/AdventNetTftp.jar
wrapper.java.classpath.29=classes/ftp.jar
wrapper.java.classpath.30=classes/jfreechart.jar
wrapper.java.classpath.31=classes/jgraph.jar
wrapper.java.classpath.32=classes/jcommon.jar
wrapper.java.classpath.33=tomcat/lib/commons-beanutils.jar
wrapper.java.classpath.34=tomcat/lib/commons-collections.jar
wrapper.java.classpath.35=tomcat/lib/commons-logging-api.jar
wrapper.java.classpath.36=tomcat/lib/commons-logging.jar
wrapper.java.classpath.37=classes/htmllexer.jar
wrapper.java.classpath.38=classes/htmlparser.jar
wrapper.java.classpath.39=classes/HTTPClient.jar
wrapper.java.classpath.40=classes/jasperreports/itext-1.01.jar
wrapper.java.classpath.41=classes/jasperreports/poi-2.0-final-20040126.jar
wrapper.java.classpath.42=classes/jasperreports/jasperreports-0.5.2.jar
wrapper.java.classpath.43=classes/RMECommon.jar
wrapper.java.classpath.44=classes/wrapper.jar
wrapper.java.classpath.45=classes/trayicon.jar
wrapper.java.classpath.46=classes/OpManagerStartupClasses.jar
wrapper.java.classpath.47=classes/AdventNetPersistence.jar
wrapper.java.classpath.48=classes/AdventNetPersistenceSA.jar
wrapper.java.classpath.49=classes/AdventNetRssLibrary.jar
wrapper.java.classpath.50=classes/commons-codec-1.3.jar
wrapper.java.classpath.51=classes/commons-httpclient-3.0-rc1.jar
wrapper.java.classpath.52=classes/jtds-1.0.3.jar
wrapper.java.classpath.53=classes/SMSServer.jar
wrapper.java.classpath.54=classes/SMSLib.jar
wrapper.java.classpath.55=classes/cryptix-jce-provider.jar
wrapper.java.classpath.56=classes/WiFiMediation.jar
wrapper.java.classpath.57=classes/OpManagerOperations.jar
wrapper.java.classpath.58=classes/axis.jar
wrapper.java.classpath.59=classes/commons-discovery.jar
wrapper.java.classpath.60=classes/commons-discovery-0.2.jar
wrapper.java.classpath.61=classes/saaj.jar
wrapper.java.classpath.62=classes/wsdl4j-1.5.1.jar
wrapper.java.classpath.63=classes/jaxrpc.jar
wrapper.java.classpath.64=classes/poi-3.0.1-FINAL-20070705.jar
wrapper.java.classpath.65=classes/iTextAsian.jar
wrapper.java.additional.8=-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
wrapper.java.additional.9=-Djava.util.logging.config.file=tomcat/conf/logging.properties
wrapper.java.additional.10=-XX:PermSize=64m
wrapper.java.additional.11=-XX:MaxPermSize=128m
wrapper.java.classpath.66=tomcat/lib/jasper.jar
wrapper.java.classpath.67=tomcat/lib/jsp-api.jar
wrapper.java.classpath.68=tomcat/bin/tomcat-juli.jar
wrapper.java.classpath.69=tomcat/lib/tomcat-dbcp.jar
wrapper.java.classpath.70=tomcat/lib/el-api.jar
wrapper.java.classpath.71=tomcat/lib/annotations-api.jar
wrapper.java.classpath.72=tomcat/lib/jasper-jdt.jar
wrapper.java.classpath.73=tomcat/lib/jasper-el.jar
wrapper.java.classpath.74=tomcat/lib/catalina-tribes.jar
wrapper.java.classpath.75=tomcat/lib/catalina.jar
wrapper.java.classpath.76=tomcat/lib/tomcat-coyote.jar
wrapper.java.classpath.77=tomcat/lib/catalina-ha.jar
wrapper.java.classpath.78=tomcat/lib/commons-digester.jar
wrapper.java.classpath.79=tomcat/lib/commons-fileupload-1.1.1.jar
wrapper.java.classpath.80=tomcat/lib/commons-io-1.2.jar
wrapper.java.classpath.81=classes/json.jar
wrapper.java.classpath.82=classes/vijava220090625.jar
wrapper.java.classpath.83=classes/dom4j-1.6.1.jar
wrapper.java.classpath.84=classes/jaxb-api.jar
wrapper.java.classpath.85=classes/jaxb-impl.jar
wrapper.java.classpath.86=classes/prefuse.jar
--------------------------------
ShutdownOpManagerServer and the startup scripts:
[root@neolog02 OpManager]# cat bin/ShutDownOpManager.sh
#!/bin/sh
#$Id: ShutDownOpManager.sh,v 1.7.4.1 2005/07/11 08:51:37 roshini Exp $
# This file can be used to ShutDown the Nms Server. It can be used from remote
# machine also. Just copy the ShutDown.class, BASE64Encoder.class and this file # to remote machine.
cd ..
. ./setEnv.sh
if [ $# -eq 2 ]
then
USER_NAME=$1
USER_PASSWD=$2
else
USER_NAME=root
fi
HOSTNAME=localhost
CLASSPATH=$NMS_CLASSES:$NMS_CLASSES/OpManagerStartupClasses.jar:$NMS_CLASSES/NmsServerClasses.jar:$NMS_CLASSES/ApiUtils.jar
export CLASSPATH
if [ $# -eq 0 ]
then
$JAVA_HOME/bin/java com.adventnet.me.opmanager.tray.ShutDownUI -HOST_NAME $HOSTNAME -USER_NAME $USER_NAME -NMS_RESOURCE_DIRECTORY $NMS_HOME/html -RESOURCE_PROPERTIES ShutDownNmsServerResources -RESOURCE_LOCALE en_US
else if [ $# -ne 2 ]
then
echo Invalid Usage
echo Usage : sh ShutDown \<username\> \<password\>
else
# Usage : java com.adventnet.nms.util.StandAloneShutDown \[-h host\] \[-u username\] \[-p password\]
$JAVA_HOME/bin/java com.adventnet.nms.util.StandAloneShutDown -h $HOSTNAME -u $USER_NAME -p $USER_PASSWD
fi
fi
[root@neolog02 OpManager]# cat bin/StartOpManagerServer.sh
#$Id: StartOpManagerServer.sh,v 1.23.4.8.4.9.4.4.2.1.6.5 2010/06/02 12:39:41 rravikumar Exp $
#echo on
# Checking whether the user is root user or not.
ID=`id | awk '{print $1}' | cut -d "=" -f2 | cut -d "(" -f1`
if [ ${ID} -ne 0 ]
then
echo "You must be a root user to start the OpManager server."
echo "Please login as root user and start the server again."
exit 1
fi
AWT_HEADLESS=
# Checking whether DISPLAY variable set the system or not.
if [ "$DISPLAY" = "" ]; then
AWT_HEADLESS=-Djava.awt.headless=true
fi
# Starting the OpManager server.
cd ..
CLASSPATH=
export CLASSPATH
. ./setEnv.sh
echo "Java Home " $JAVA_HOME
export LD_LIBRARY_PATH
#Please do not edit this entry, it will be used by the DeploymentWizard tool
CUSTOMPATH=
#Please do not remove/edit this entry, it will be used by the MOWizard tool
MOPATH=
SSL_CHK=
### The following lines are removed as apache is removed and only tomcat is used. The operation corrsponding to apache is commented below.
#if [ $WEBSERVER_HOME/ssl/backup/ssl.conf ]
#then
#cp -f $WEBSERVER_HOME/ssl/backup/ssl.conf $WEBSERVER_HOME/ssl
#SSL_CHK=$WEBSERVER_HOME/ssl/ssl.conf
#fi
#cp -f $WEBSERVER_HOME/conf/backup/httpd.conf $WEBSERVER_HOME/conf
cp -f $TOMCAT_HOME/conf/backup/server.xml $TOMCAT_HOME/conf
cp -f $TOMCAT_HOME/conf/backup/workers.properties $TOMCAT_HOME/conf
#cp -f $TOMCAT_HOME/conf/backup/mod_jk.conf-auto $TOMCAT_HOME/conf/mod_jk.conf-nms
#cp -f $WEBSERVER_HOME/bin/backup/* $WEBSERVER_HOME/bin
#CLASSPATH variable is changed to CLASS_PATH . If the classpath is set by using #the CLASSPATH variable ,RMI will load the classes from the CLASSPATH and not fr#om the codebase.
# LICENSE_PATH variable is to locate AdventNetLicense.ali directory path.
CLASS_PATH=$NMS_CLASSES:$NMS_CLASSES/WiFiMediation.jar:$NMS_CLASSES/jaxb-api.jar:$NMS_CLASSES/jaxb-impl.jar:$NMS_CLASSES/dom4j-1.6.1.jar:$NMS_CLASSES/vijava220090625.jar:$NMS_CLASSES/SMSServer.jar:$NMS_CLASSES/SMSLib.jar:$NMS_CLASSES/cryptix-jce-provider.jar:$NMS_CLASSES/OpManagerServerClasses.jar:$NMS_CLASSES/OpManagerCharts.jar:$NMS_CLASSES/OpManagerBeans.jar:$NMS_CLASSES/AdventNetLogging.jar:$NMS_CLASSES/OpManagerClientClasses.jar:$NMS_CLASSES/NmsServerClasses.jar:$NMS_CLASSES/RMECommon.jar:$NMS_CLASSES/AdventNetPersistence.jar:$NMS_CLASSES/AdventNetPersistenceSA.jar:$NMS_CLASSES/OpManagerStartupClasses.jar:$SUM_CLIENT_CLASSPATH:$SUM_SERVER_CLASSPATH:$CUSTOMPATH:$SNMP_CLASSPATH:$SAS_CLASSPATH:$XML_CLASSPATH:$OTHER_CLASSPATH:$MS_CLASSPATH:$WEBSERVER_CLASSPATH:$DB_CLASSPATH:$JAVA_CLASSPATH:$BUILDER_CLASSPATH:$TFTP_CLASSPATH:$CLI_CLASSPATH:$TRANSACTION_CLASSPATH:$NMS_CLASSES/AdventNetSnmpDistributedAPI.jar:$JIMI_CLASSPATH:$MOPATH:$LICENSE_PATH:$FTP_CLASSPATH:$JGRAPH_CLASSPATH:$JFREE_CHARTS_CLASSPATH:$JASPER_CLASSPATH:$HTTP_CLIENT_CLASSPATH:$RSS_CLASSPATH:$NMS_CLASSES/j2ssh-common.jar:$NMS_CLASSES/j2ssh-core.jar:$NMS_CLASSES/OpManagerOperations.jar:$NMS_CLASSES/axis.jar:$NMS_CLASSES/commons-discovery.jar:$NMS_CLASSES/commons-discovery-0.2.jar:$NMS_CLASSES/saaj.jar:$NMS_CLASSES/wsdl4j-1.5.1.jar:$NMS_CLASSES/jaxrpc.jar:$NMS_CLASSES/poi-3.0.1-FINAL-20070705.jar:$NMS_CLASSES/json.jar:$NMS_CLASSES/prefuse.jar
# Uncomment the following lines for using TL1 Protocol.
CLASS_PATH=$CLASS_PATH:$TL1_CLASSPATH
# Uncomment the following lines for using JMX Agent.
CLASS_PATH=$CLASS_PATH:$JMX_AGENT_CLASSPATH
JAVA_OPTS="-Dwebserver.rootdir=$WEBSERVER_HOME -Dwebnms.rootdir=$NMS_HOME -Dwebcontainer.home=$TOMCAT_HOME -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=$TOMCAT_HOME/conf/logging.properties"
#As apache is removed, passing of apache related files as arguments is removed.
$JAVA_HOME/bin/java -cp $CLASS_PATH $AWT_HEADLESS $JAVA_OPTS com.adventnet.me.opmanager.server.OpManagerInitWebSvr $TOMCAT_HOME/conf/server.xml $TOMCAT_HOME/conf/workers.properties
# Usage: java com.adventnet.nms.startnms.NmsMainBE [NATIVE_PING true/false] [BE_FE TCP/RMI] [NMS_BE_PORT back_end_port_num] [COUNTRY country_code] [LANGUAGE language_code] [SERVICE true/false] [USERS_DIR userDir] [ROOT_DIR rootDir]
if [ $? != 0 ]
then
exit 1
fi
#if [ ! -f $NMS_HOME/conf/startup.txt ]
#then
# $JAVA_HOME/bin/java -cp $NMS_CLASSES:$NMS_CLASSES/OpManagerStartupClasses.jar:$NMS_CLASSES/NmsClientClasses.jar:$NMS_CLASSES/OpManagerClientClasses.jar:$NMS_CLASSES/ApiUtils.jar:$NMS_CLASSES/OpManagerBeans.jar:$NMS_CLASSES/AdventNetUtils.jar:$NMS_CLASSES/GenVarPanel.jar:$NMS_CLASSES/JimiProClasses.zip:$NMS_CLASSES/AdventNetSnmp.jar:$NMS_CLASSES/AdventNetProBeans.jar:$NMS_CLASSES/AdventNetDMPModels.jar:$NMS_CLASSES/OpManagerImages.jar:$NMS_CLASSES/OpManagerServerClasses.jar:$OTHER_CLASSPATH:$NMS_CLASSES/NmsServerClasses.jar com.adventnet.me.opmanager.tray.DiscoveryWizard
# touch $NMS_HOME/conf/startup.txt
#fi
while(true)
do
$JAVA_HOME/bin/java -cp $CLASS_PATH $AWT_HEADLESS $JAVA_OPTS -Dcatalina.home=$TOMCAT_HOME -Dmysql.home=$MYSQL_HOME -Djava.rmi.server.codebase="$CODEBASE_LIST" -Xms512m -Xmx1024m -XX:PermSize=1024m -XX:MaxPermSize=1024m com.adventnet.me.opmanager.server.OpManagerMainBE ROOT_DIR $NMS_HOME NMS_BE_FAILOVER true $*
if [ $? -eq 126 -o -f Patch/smarttmp.txt ]; then
$JAVA_HOME/bin/java -cp $UPDATE_MANAGER_CLASSPATH com.adventnet.tools.update.installer.UpdateManager -u conf -h $NMS_HOME -c
if [ $? -ne 0 ]; then
exit
fi
else
exit;
fi
done
[root@neolog02 OpManager]#
------------------------------------
[root@neolog02 OpManager]# mysqld --version
mysqld Ver 5.0.46-enterprise-gpl-log for redhat-linux-gnu on x86_64 (MySQL Enterprise Server (GPL))
-----------------------
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
low_priority_updates=1
concurrent_insert=2
skip-external-locking
#skip-ndbcluster
#skipbdb
key_buffer_size = 400M
bulk_insert_buffer_size=50M
max_allowed_packet = 16M
table_cache = 2048
sort_buffer_size = 10M
read_buffer_size = 10M
read_rnd_buffer_size = 10M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
myisam_max_sort_file_size=50M
query_cache_size = 200M
query_cache_limit = 10M
thread_concurrency = 8
join_buffer_size=10M
#skip-networking
tmp_table_size=200M
max_heap_table_size=200M
log-bin=mysql-bin
expire_logs_days=15
server-id = 1
#log-bin=mysql-bin
tmpdir = /data1/appz/mysql/tmp
#log-update = /path-to-dedicated-directory/hostname
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 384M
#bdb_max_lock = 100000
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 400M
innodb_additional_mem_pool_size = 128M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
innodb_log_buffer_size = 10M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[root@neolog02 OpManager]#
-------------
Can you suggest some tuning paramaters to help speed this box up for the eval? There is nothing else this box will do except for recieve syslogs form all devices (3000+ network devices) so that OpManager can do alerts, run OpManager for 300-400 network devices, and Device Expert (that eval is doing after this one.).
So our Systems guys said that we should ask about tuning not only MYSQL, but also about tuning the .SH scritps we have, and definately tuning the TOMCAT/APACHE.
Would appreciate any help.