MySQL Bugs: #59872: Document InnoDB pool requirements for existing MySQL repository

Bug #59872	Document InnoDB pool requirements for existing MySQL repository
Submitted:	1 Feb 2011 17:45	Modified:	11 May 2011 20:42
Reporter:	Andrii Nikitin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Documentation	Severity:	S3 (Non-critical)
Version:	2.3.1	OS:	Any
Assigned to:	John Russell	CPU Architecture:	Any

Description:
https://enterprise.mysql.com/docs/monitor/2.3/en/mem-install.html#mem-install-server

"MySQL Server selection" at link above doesn't show minimal innodb_buffer_pool_size requirements. Tomcat may flood logs with strange errors like "Session is closed!" when this parameter has default value (8M).

How to repeat:
see link above

Suggested fix:
Document minimal value for innodb_buffer_pool_size .

Gary Whizin writes: 
should recommend the values we use in my.cnf that's included in our full install

Andy Bang writes: 
Here is the default my.cnf that we currently ship with the Service Manager:

[client]
port = @@MYSQL_PORT@@
socket = @@MYSQL_ROOTDIR@@/tmp/mysql.sock

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

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

# SSL
ssl-ca="@@MYSQL_ROOTDIR@@/ssl/cacert.pem"
ssl-cert="@@MYSQL_ROOTDIR@@/ssl/server-cert.pem"
ssl-key="@@MYSQL_ROOTDIR@@/ssl/server-key.pem"

# If you wish to use binary logging (e.g. for replicating the MySQL
# Enterprise Monitor's data repository), please uncomment both of the
# following two options.  ROW-based binary logging is essential for
# the smooth running of the application.

# log-bin = @@MYSQL_ROOTDIR@@/data/monitor.log
# binlog_format = ROW

server-id = 1
secure_auth = 1
skip-external-locking
lower_case_table_names = 1
default-storage-engine = InnoDB

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
innodb_locks_unsafe_for_binlog = 1

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

This information is present now on: http://dev.mysql.com/doc/mysql-monitor/2.3/en/mem-server-install-generic.html