Bug #40656 Default Merlin Service Manager config settings are too low
Submitted: 12 Nov 2008 0:39 Modified: 14 Nov 2008 19:35
Reporter: Andy Bang Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Installing Severity:S3 (Non-critical)
Version:2.0.0.7092 OS:Any
Assigned to: Andy Bang CPU Architecture:Any
Triage: Needs Triage: D3 (Medium) / R2 (Low) / E2 (Low)

[12 Nov 2008 0:39] Andy Bang
Description:
The default Tomcat and MySQL settings are not sufficient for monitoring more than a few servers.

How to repeat:
1) Install the Service Manager.
2) Review the catalina.sh and my.cnf files.

Suggested fix:
1) Use the following for my.cnf:

[client]
port = @@BITROCK_MYSQL_PORT@@
socket = @@BITROCK_MYSQL_ROOTDIR@@/tmp/mysql.sock

[mysql]
port = @@BITROCK_MYSQL_PORT@@
no-auto-rehash
prompt = \u@\h [\d]>\_

[mysqld]
port = @@BITROCK_MYSQL_PORT@@
basedir = @@BITROCK_MYSQL_ROOTDIR@@/
datadir = @@BITROCK_MYSQL_ROOTDIR@@/data/
socket = @@BITROCK_MYSQL_ROOTDIR@@/tmp/mysql.sock
pid-file = @@BITROCK_MYSQL_ROOTDIR@@/data/mysqld.pid

server-id = 1
secure_auth = 1
skip-locking
lower_case_table_names = 1

innodb_data_file_path = ibdata1:500M:autoextend
innodb_autoextend_increment = 50M
innodb_buffer_pool_size = 512M
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 2
innodb_support_xa = 0
innodb_file_per_table
innodb_max_dirty_pages_pct = 20

table_cache = 256
thread_cache_size = 16
max_heap_table_size = 32M

tmp_table_size = 32M
sort_buffer_size = 512K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
max_allowed_packet = 1M

2) Make the following change in catalina.sh:

   Change:
   JAVA_OPTS="$JAVA_OPTS -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=$CATALINA_BASE/tmp -server"

   To:
   JAVA_OPTS="$JAVA_OPTS -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=$CATALINA_BASE/tmp -Xmx768M -Xms768M -Xss128k -XX:+UseParallelOldGC -XX:+UseBiasedLocking -server"

Note that on Windows the extra parameters are set in mysqlmonitorctl.bat, not in catalina.bat or catalina.sh.

3) In config.properties, we'd like the following (along with the
   comment):

     # max connections in the pool for the repository
     default.maxActive=70
[12 Nov 2008 0:40] Andy Bang
Changes are committed and ready for the next build.
[12 Nov 2008 16:12] Carsten Segieth
On Linux it's the same as on Mac (which Marcos tested).
[13 Nov 2008 14:53] Keith Russell
Patch applied in build versions => 2.0.0.7095.
[14 Nov 2008 19:35] Bill Weber
confirmed that all these changes were made in build 2.0.0.7097