Thread: Mailbox Stopped
View Single Post
  #8 (permalink)  
Old 11-22-2005, 06:44 PM
jono jono is offline
Intermediate Member
 
Posts: 18
Default Ram size

That server has 2Gb RAM installed, surely you can't tell me that's not enough for a base install with no users set up?

hw.memsize: 2147483648

I chopped chunks out of this so to remain relevant

++ export logger_mysql_bind_address=localhost
++ logger_mysql_bind_address=localhost
++ export logger_mysql_data_directory=/opt/zimbra/logger/db/data
++ logger_mysql_data_directory=/opt/zimbra/logger/db/data
++ export logger_mysql_directory=/opt/zimbra/logger/mysql
++ logger_mysql_directory=/opt/zimbra/logger/mysql
++ export logger_mysql_mycnf=/opt/zimbra/conf/my.logger.cnf
++ logger_mysql_mycnf=/opt/zimbra/conf/my.logger.cnf
++ export logger_mysql_pidfile=/opt/zimbra/logger/db/mysql.pid
++ logger_mysql_pidfile=/opt/zimbra/logger/db/mysql.pid
++ export logger_mysql_port=7307
++ logger_mysql_port=7307
++ export logger_mysql_socket=/opt/zimbra/logger/db/mysql.sock
++ logger_mysql_socket=/opt/zimbra/logger/db/mysql.sock
++ export mysql_bind_address=localhost
++ mysql_bind_address=localhost
++ export mysql_data_directory=/opt/zimbra/db/data
++ mysql_data_directory=/opt/zimbra/db/data
++ export mysql_directory=/opt/zimbra/mysql
++ mysql_directory=/opt/zimbra/mysql
++ export mysql_innodb_log_buffer_size=8388608
++ mysql_innodb_log_buffer_size=8388608
++ export mysql_innodb_log_file_size=104857600
++ mysql_innodb_log_file_size=104857600
++ export mysql_logger_root_password=XXXXremovedXXXX
++ mysql_logger_root_password=XXXXremovedXXXX
++ export mysql_memory_percent=40
++ mysql_memory_percent=40
++ export mysql_mycnf=/opt/zimbra/conf/my.cnf
++ mysql_mycnf=/opt/zimbra/conf/my.cnf
++ export mysql_pidfile=/opt/zimbra/db/mysql.pid
++ mysql_pidfile=/opt/zimbra/db/mysql.pid
++ export mysql_port=7306
++ mysql_port=7306
++ export mysql_read_buffer_size=1048576
++ mysql_read_buffer_size=1048576
++ export mysql_root_password=XXXXremovedXXXX
++ mysql_root_password=XXXXremovedXXXX
++ export mysql_socket=/opt/zimbra/db/mysql.sock
++ mysql_socket=/opt/zimbra/db/mysql.sock
++ export mysql_sort_buffer_size=1048576
++ mysql_sort_buffer_size=1048576
++ export mysql_table_cache=500
++ mysql_table_cache=500
++ export smtp_destination=XXXXremovedXXXX
++ smtp_destination=XXXXremovedXXXX
++ export smtp_notify=yes
++ smtp_notify=yes
++ export smtp_source=aXXXXremovedXXXX
++ smtp_source=XXXXremovedXXXX
++ export snmp_notify=yes
++ snmp_notify=yes
++ export snmp_trap_host=XXXXremovedXXXX
++ snmp_trap_host=XXXXremovedXXXX
++ export ssl_allow_untrusted_certs=TRUE
++ ssl_allow_untrusted_certs=TRUE
++ export stats_img_folder=/opt/zimbra/zimbramon/rrdtool/work
++ stats_img_folder=/opt/zimbra/zimbramon/rrdtool/work
++ export tomcat_directory=/opt/zimbra/tomcat
++ tomcat_directory=/opt/zimbra/tomcat
++ export tomcat_java_heap_memory_percent=30
++ tomcat_java_heap_memory_percent=30
++ export tomcat_java_home=/usr
++ tomcat_java_home=/usr
++ export 'tomcat_java_options=-client -XX:NewRatio=2'
++ tomcat_java_options=-client -XX:NewRatio=2
++ export tomcat_keystore=/opt/zimbra/tomcat/conf/keystore
++ tomcat_keystore=/opt/zimbra/tomcat/conf/keystore
++ export tomcat_pidfile=/opt/zimbra/log/tomcat.pid
++ tomcat_pidfile=/opt/zimbra/log/tomcat.pid
++ export zimbra_db_directory=/opt/zimbra/db
++ zimbra_db_directory=/opt/zimbra/db
++ export zimbra_extension_directory=/opt/zimbra/lib/ext
++ zimbra_extension_directory=/opt/zimbra/lib/ext
++ export zimbra_gid=502
++ zimbra_gid=502
++ export zimbra_home=/opt/zimbra
++ zimbra_home=/opt/zimbra
++ export zimbra_index_directory=/opt/zimbra/index
++ zimbra_index_directory=/opt/zimbra/index
++ export zimbra_index_idle_flush_time=600
++ zimbra_index_idle_flush_time=600
++ export zimbra_index_lru_size=100
++ zimbra_index_lru_size=100
++ export zimbra_index_max_uncommitted_operations=200
++ zimbra_index_max_uncommitted_operations=200
++ export zimbra_java_home=/usr
++ zimbra_java_home=/usr
++ export zimbra_ldap_password=XXXXremovedXXXX
++ zimbra_ldap_password=XXXXremovedXXXX
++ export zimbra_ldap_userdn=uid=zimbra,cn=admins,cn=zimbra
++ zimbra_ldap_userdn=uid=zimbra,cn=admins,cn=zimbra
++ export zimbra_log4j_properties=/opt/zimbra/conf/log4j.properties
++ zimbra_log4j_properties=/opt/zimbra/conf/log4j.properties
++ export zimbra_log_directory=/opt/zimbra/log
++ zimbra_log_directory=/opt/zimbra/log
++ export zimbra_logger_mysql_password=XXXXremovedXXXX
++ zimbra_logger_mysql_password=XXXXremovedXXXX
++ export zimbra_mysql_connector_maxActive=10
++ zimbra_mysql_connector_maxActive=10
++ export zimbra_mysql_password=XXXXremovedXXXX
++ zimbra_mysql_password=XXXXremovedXXXX
++ export zimbra_mysql_user=zimbra
++ zimbra_mysql_user=zimbra
++ export zimbra_server_hostname=XXXXremovedXXXX
++ zimbra_server_hostname=XXXXremovedXXXX
++ export zimbra_store_directory=/opt/zimbra/store
++ zimbra_store_directory=/opt/zimbra/store
++ export zimbra_uid=502
++ zimbra_uid=502
++ export zimbra_user=zimbra
++ zimbra_user=zimbra
+ export zmsetvars=true
+ zmsetvars=true
++ /opt/zimbra/bin/get_plat_tag.sh
+ platform=MACOSX
+ '[' xMACOSX = xMACOSX ']'
++ nvram -p
++ awk '/^ram-size/ {print $2}'
+ memhex=-2147483648
++ printf %d -2147483648
+ mem=-2147483648
++ expr -2147483648 / 1024
+ memkb=-2097152
+ (( mymem=memkb * 1024 * mysql_memory_percent / 100 ))
+ (( computed_innodb_buffer_pool_size = mymem * 75 / 100 ))
+ (( non_buffer_pool_memory = mymem - computed_innodb_buffer_pool_size ))
+ (( per_connection_memory = 2097152 + mysql_sort_buffer_size + mysql_read_buffer_size + mysql_innodb_log_buffer_size ))
+ (( computed_max_connections = non_buffer_pool_memory / per_connection_memory ))
+ '[' -17 -lt 10 ']'
+ computed_max_connections=10
+ (( mysql_read_buffer_size = non_buffer_pool_memory / computed_max_connections * 1 / 10 ))
+ (( mysql_sort_buffer_size = non_buffer_pool_memory / computed_max_connections * 1 / 10 ))
+ (( mysql_innodb_log_buffer_size = non_buffer_pool_memory / computed_max_connections * 8 / 10 ))
+ /opt/zimbra/bin/zmlocalconfig -e zimbra_mysql_connector_maxActive=10
+ (( computed_max_connections = computed_max_connections + 4 ))
+ cat

[mysqld]

basedir = /opt/zimbra/mysql
datadir = /opt/zimbra/db/data
socket = /opt/zimbra/db/mysql.sock
pid-file = /opt/zimbra/db/mysql.pid
bind-address = localhost
port = 7306

skip-external-locking

log-slow-queries = /opt/zimbra/log/myslow.log
long-query-time = 1
log-long-format
log-queries-not-using-indexes
log-bin

thread_cache = 14
max_connections = 14

# We do a lot of writes, query cache turns out to be not useful.
query_cache_type = 0

sort_buffer_size = -2147483
read_buffer_size = -2147483

# Increase the size of the table cache, since each mailbox has its
# own set of tables
table_cache = 500

innodb_buffer_pool_size = -644245094
innodb_log_file_size = 104857600
innodb_log_buffer_size = -17179868
innodb_file_per_table

[mysqld_safe]

err-log = /opt/zimbra/log/mysqld.log
Reply With Quote